AnsweredAssumed Answered

Help with Lookup

Question asked by juan.segovia on Apr 9, 2012
Latest reply on Apr 10, 2012 by juan.segovia
Hi, I was wondering if anyone can give me an idea on this since, I'm not good with NSQL.

I need to create a lookup that calls resources but only the ones that belong to an specific Security Group in Clarity.

Similar to the standard resource browse lookup included in Clarity:











FROM srm_resources r,

cmn_sec_users u,

cmn_lookups_v l,

cmn_lookups_v s

WHERE = r.user_id


AND r.person_type =

AND l.language_code=@WHERE:PARAM:LANGUAGE@

AND l.lookup_type='SRM_RESOURCE_TYPE'

AND u.user_status_id =

AND s.language_code= @WHERE:PARAM:LANGUAGE@

AND s.lookup_type='SEC_USER_STATUS'
AND s.lookup_code IN ('ACTIVE','LOCK')


But just showing the ones belonging to a specific security group. Is this possible?