Remove a choice from a variable which is populated through Reference qualifier.

[1_DipikaD]

Hi All ,

I want to remove Brazil from country variable which is a look up select box(refers to a custom table) with variable attribute and reference qualifier with it as shown in the below picture . How to remove Brazil and to add other choices to the country variable . 

When I select region= America in country field displays 3 choices that are fetched from referenced table based on the reference qualifier.

Country Variable :-

variable attribute -- >    ref_qual_elements=region

Refers to table ---> 

Please let me know if you need more info .

Thank you

[Nawal Singh]

Hi @1_DipikaD ,

Replace your current reference qualifier  with-

javascript:'u_region=' + current.variables.region.toString() + '^u_country!=Brazil';

Please test and review

If you found my response helpful, please mark it as helpful and accept it as the solution.

Thank you
Nawal Singh

[Ankur Bawiskar]

@1_DipikaD 

simply exclude that 1 record by giving like this

javascript:'u_region=' + current.variables.region.toString() + '^u_country!=Brazil';

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[1_DipikaD]

Hi @Ankur Bawiskar & @Nawal Singh ,

Tried this - javascript:'u_region='+current.variables.region.toString()+ 'u_country!= Brazil';

But it removed all choices with Brazil .

Thank you 

[Ankur Bawiskar]

@1_DipikaD 

Brazil comes under America

So as per your requirement when America is selected in Region then you don't want to see Brazil Country?

If yes then above ref qualifier will work fine.

if not then what's your actual requirement?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏