Clarity

Hello,

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. Any help is appreciated.

/Sai.

May be a stupid question, but did you actually press the 'Filter' button on the screen shot labelled 'Filter not working from admin side'?

Additional observation, you have made the filter attribute 'Select Team Member Type' mandatory in the first screen shot, whilst the second screen shot is not mandatory, you may want to try it non-mandatory.

Can you also paste relevant sections of the NSQL code for the Query?