Skip to main content
Solved

Lookup File Expression on Job Titles


Forum|alt.badge.img+7

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 @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.

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • 13 replies
  • Answer
  • July 23, 2024

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.


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Customer)
  • 20 replies
  • July 23, 2024

Thanks @momboc 

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings