Reference Qualifier Issue

abirakundu23
Mega Sage

Hi All,

There is requirement we don't want to select employee from "Employee" dropdown list for "IN" country from record producer. Put the condition wrt to employee's country from user's table & there is another country field from HR profile table. If both countries are same its working fine but country is different in User's table & another country field in HR profile table, it's not working. Able to select Employee from "Employee" dropdown.

Please guide me.

 javascript:user.location.country!=IN^u_country!=IN

5 REPLIES 5

Tai Vu
Kilo Patron
Kilo Patron

Hi @abirakundu23 

Can you give a couple of screenshot for better understanding?

 

Cheers,

Tai Vu

Pankaj kr
Kilo Sage

Hi Akadu,

 

This is happening because you are using and( ^ ) operator in your reference qualifier. You should use or( || ) operator and it will work fine. 

 javascript:user.location.country!=IN||u_country!=IN

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Pankaj Kumar

abirakundu23
Mega Sage

HI @Pankaj kr ,

Checked for OR condition its not working.

 

Pavankumar_1
Mega Patron

Hi @abirakundu23 ,

that is correct because you are using AND condition if both matches it will work.

Try like below query

javascript: user.location.country!=IN^ORu_country!=IN
If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar