City Column Value of cmn_location table to my field

[Prabneet]

Hi all,

I have a requirement where I have a Reference field 'Work Location' for which I have to pick the City Column value of the cmn_location table. Issue is that it always display the 'Name' column field instead of the City column value. I tried the dynamic reference qualifier but see no difference. Any suggestions!

[Alberto Consonn]

Hi @Prabneet 

type cmn_location.list in the Application Navigator, go to Configure > Table and then filter the column "City" and set the Default value to true, then press Update.

If I have answered your question, please mark my response as correct and helpful so that others with the same question in the future can find it quickly and that it gets removed from the unanswered list.

Thank you very much

Cheers
Alberto