We want to apply Lookup Filter Expression on Job Title Field based on CSG.
Something like below:
select UserRole.Id from usr_role as UserRole where UserRole.csg.shortCode=’XYZ’;
But this expression is failing. Please help in fixing this.
We want to apply Lookup Filter Expression on Job Title Field based on CSG.
Something like below:
select UserRole.Id from usr_role as UserRole where UserRole.csg.shortCode=’XYZ’;
But this expression is failing. Please help in fixing this.
Best answer by momboc
Hi
Try this:
from usr_role as UserRole where UserRole.csg_sc = 'XYZ’;
Also, if you have CSGs Activated on Job Title, your users should only be able to see the Job Titles that have a CSG that they are restricted to via their assyst user or User Alias form.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.