Validate the country against list of groups and return groups which are validated

[Ash41]

Hi Team, 

From user profile country, we want to validate with field on "ABC table" which is list collector field type "group" inside it we have country field. Only if match between User profile country and Group.country is done, that groups only should returned. how to to achieve it

[Tai Vu]

Hi @Ash41 

Not sure if I understand correctly. At the List Collector field when you do the lookup, are you trying to show the list of groups that have the country as same as the user's country?

Cheers,

Tai Vu

[Ash41]

Correct, need to check user country on groups

[Tai Vu]

Hi @Ash41 

So you can set the reference qualifier in the list collector dictionary.

Simple type

Advanced type

javascript: (!gs.nil(current.u_country)) ? 'u_country=' + current.u_country : 'sys_id=-1';

Cheers,

Tai Vu

[Ash41]

Actually I need a script to return groups to pass into one of action in flow. So, trying to query with user country and group's country.