Reference Qualifier Issue

[abirakundu23]

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

[Pankaj kr]

Hi Akadu,

You can use the query provided by Pavankumar, Hope you understand the reasoning behind it.

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