How to populate only country names in the reference variable

[Roxi1]

We have a variable in one catalog item, that reference variable is pointing to cmn_location table. when i click it is showing names of the location, instead it should show only country names in the variable

how can i achieve this.

we tried to put some value like ref_ac_columns= u_country;

but it is not working

[Ahmmed Ali]

Hello @Roxi1 

If you want only countries to be selected then why not change variable reference to core_country table?

Let me know if any particular use case you are trying to achieve.

Thank you,

Ali

[Amrit4]

Go to the cmn_location table. Right click on column options:

 once the page opens--> go to Table column dictionary entries. Here mark the display value for column label 'City' as 'True' and mark the display value for column label 'Name as' 'False'

 Then go up at the right and click on update. Make sure you click on update after changing the values.

Please be kind enough to Mark my answer correct once you implement this solution

[Upsilon]

Hi, 

Try to use lookup select box rather than a reference variable. This way, you avoid the large impact if you change display field on cmn_location:

I hope it helps, 

Regards