We have a requirement to limit the selected users on system lookup field (contact user) to get users that their aliases are members of specific secondary service departments.
If it was primary service department it would be more straight forward, but for secondary service departments I tried many expressions but all failed.
Any ideas?
Hello Asoloh,
Based on the information provided the following expression should achieve what you are looking for
select contactUser.id
from usr as contactUser
join contactUser.usrAlias ua
join ua.secondaryServDepts secSvds
join secSvds.servDept secSvd
where ua.shortCode like 'ZZ_S0%' (or you can use where ua.shortCode=’usrAlias shortcode’)
and ua.servDept.shortCode = 'ASSYSTNET MBS GEN 420'
and secSvd.shortCode = 'ASSYSTNET MBS GEN430'
Please let us know if this answers your query.
Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.