Hello David,
I was able to write the Lookup Code successfully, but when I configured the Field from Admin Side, in the Filter Section, the filter does not work.
where as the filter is working fine when i configured from personalize section to myself. Below is the screenshot as mentioned.
Filter not working from Admin Side: -
Filter working from Configure Section:-
Below is the Lookup Code used for the "Select Team Member Type Attribute" mentioned above:-
select NAME B2,lookup_code c2 from cmn_lookups_v
where lookup_type='BUSINESS_IT' and language_code='en'
@BROWSE-ONLY:
AND (NOT EXISTS
(SELECT 'business_user' B1
FROM CMN_SEC_GROUPS SEC_GRPS
JOIN CMN_SEC_USER_GROUPS USER_GRPS
ON USER_GRPS.GROUP_ID=SEC_GRPS.ID AND SEC_GRPS.GROUP_CODE='unum_bus_users'
WHERE USER_GRPS.USER_ID=@WHERE:PARAM:USER_ID@ )
OR lookup_code='business_user')
:BROWSE-ONLY@
AND @FILTER@
Static BUSINESS_IT lookup used in the above lookup query:-
Thank you in Advance.
/Sai.