Replies posted by Oshadi C

1 Reply

A
Do Gooder (Customer)
asolohDo Gooder (Customer)
asked in assyst General

Contact User Lookup Filter - AssystUserAlias - SecondaryServDept

Hello Asoloh,Based on the information provided the following expression should achieve what you are looking forselect contactUser.idfrom usr as contactUserjoin contactUser.usrAlias uajoin ua.secondaryServDepts secSvdsjoin secSvds.servDept secSvdwhere 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. 

1
O
Do Gooder (Employee)
4 months ago

Badges

Show all badges
Terms & ConditionsCookie settings