reference qualifier to show required locations

[kiran kumar m1]

I have a location field (reference field ) its upon cmn_location table when I click on the field its showing all the locations present in it, cant I make it such that it only show the locations that I want? is there any reference qualifier for this?

[SAI VENKATESH]

Hi @kiran kumar m1 

You can write the below condition in the variable as attached in the image below:

Thanks and Regards

Sai Venkatesh

[Community Alums]

@kiran kumar m1 you can add the "reference qualifier condition". 

[VEEN PRANEETH K]

Hi @kiran kumar m1 

You can use the advance reference qualifiers as follow:
Here I used same "cmn_location" table, and query as "citySTARTSWITHsan" diplays only cities that start  with "san"

Thanks, 

Veena Praneeth