Skip to main content
Solved

Lookup File Expression on Job Titles

  • 23 July 2024
  • 2 replies
  • 31 views

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.

2 replies

M
Rank
Userlevel 1
Badge +2

Hi @Manish Verma ,

 

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.

M
Rank
Userlevel 2
Badge +7

Thanks @momboc 

Replacing UserRole.csg.shortCode with UserRole.csg_sc fixed the issue.

Reply


Terms & ConditionsCookie settings