Relation form fields

[luciandex]

Need some help
I have 3 tables countries and cities and places
Country hasMany cities
City belongsTo country
Place belongsTo city

Now, I want to make a relation field (backend) that show City name AND Country name.
I tried concat(name, ' - ', country) but no way for success
I tried some SQL syntax, but failed

My city-country field is:

    city:
        span: auto
        select: concat(name, ' - ', country)
        type: relation
        relation: city

What supposed to do to properly show city - country?

[luciandex]

Mr BennoThommo told me to add the question on Github.
The question is also available at: https://discord.com/channels/816852513684193281/821159568763125800/834351655457128458

[bennothommo]

@iMateo it's fine to post questions like this, in case it's something that can be done with a configuration change or some other edit in Winter.

[rubenvanerk]

You could do something like this:

    city:
        span: auto
        type: relation
        relation: city
        valueFrom: label

In your City model add:

public function getLabelAttribute()
{
    return $this->name . ' - ' . $this->country->name;
}

[luciandex]

Thank you very much. I appreciate!

[LukeTowers]

Your SQL probable didn't work if you were on SQLite because SQLite's format for concatenation is different than MySQL. @bennothommo what do you think about adding a selectConcat: property to list columns using the functionality added in wintercms/storm@d72caf0#diff-ebb1085e1718aba388c6af56be4efcb22ca61286743082c970d9b62300bcf2c5

[luciandex]

@LukeTowers , I am on MySQL in Docker.
Anyway:
The answer above din not solved my problem.
I did another way. (something with filterFields() and hide fields that holds proper id's to be sent at creation/save time.
For the moment I explore.
@rubenvanerk , that not working probably because of my models relationships. I will try with new modified relations.

[josephcrowell]

I would load the Winter.Location plugin and use that for your Country and State/Territory relations