Populate the location based on country

Haresh Haru · ‎09-06-2023

I have requerement like in catalog item we have two fields called county and location both are referenced by cmn_location table so if i select country field as india then it show the only india based locations like bangalore, hyd ect ...

So can please help me on this ....

Regards

Haresh

Sagar Pagar · ‎09-07-2023

Hi @Haresh Haru,

Make sure that the variables name are correct.

Both are referenced to the same table i.e. cmn_location. hence you need to query with country column.

javascript&colon;if(current.variables.country_variable_name != ''){
"country=" + current.variables.country_variable_name.country;
}

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers! 👍🏻
Thanks,
Sagar Pagar

The world works with ServiceNow

View solution in original post

Vishal Birajdar · ‎09-07-2023

Hi @Haresh Haru

Check if "Parent" is the common for specific location.

javascript&colon; "parent=" + current.variables.country;

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

anshul_goyal · ‎09-07-2023

Hi @Haresh Haru,

Use the Advanced reference qualifier below:

javascript&colon; "country="+ current.variables.country.country;

Output:

Location Table filter condition:

If my answer solves your issue, please mark it as Helpful and Accepted.

Thanks,
Anshul