Include specific field in response

[dpetrovaliev]

Hey, i have the following scenario: I should have a way to search cities by name and return the cities along with their country and state code: Here is my action:

$action = World::cities([
            'fields' => 'country,state',
            'search' => $request->get('query')
        ]);

As a result, I'm not receiving the state code but only the state id and state name. Is there any way to preload the states with the state_code?

[nnjeim]

@dpetrovaliev please look at the outcome here below state code do not exist it is only state id and state name

[dpetrovaliev]

@nnjeim yes and the question was, how could I include it?

I think I found a solution:

added the state_code in the optional fields in world.php config file and then recreated all the tables and then included state_code in fields when searching cities.

[nnjeim]

@dpetrovaliev excellent, thank you for your input