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:

[color=#f63d3d]SELECT @SELECT:u.id:user_id@,





@SELECT:u.user_name:user_name@,





@SELECT:u.user_name:UNIQUE_CODE@,





@SELECT:r.id:resource_id@,





@SELECT:r.unique_name:unique_name@,





@SELECT:r.first_name:first_name@,





@SELECT:r.last_name:last_name@,





@SELECT:r.full_name:full_name@,





@SELECT:r.unique_name:resourceID@,





@SELECT:r.person_type:person_type_id@,





@SELECT:l.name:person_type@,





@SELECT:u.user_status_id:user_status_id@,





@SELECT:s.name:user_status@




FROM srm_resources r,







cmn_sec_users u,







cmn_lookups_v l,







cmn_lookups_v s




WHERE u.id = r.user_id




AND @FILTER@




AND r.person_type = l.id




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




AND l.lookup_type='SRM_RESOURCE_TYPE'




AND u.user_status_id = s.id




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




AND s.lookup_type='SEC_USER_STATUS'
@BROWSE-ONLY:
AND s.lookup_code IN ('ACTIVE','LOCK')
:BROWSE-ONLY@




AND @WHERE:SECURITY:RESOURCE:r.id@[color]

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

Thanks.

Juan

Outcomes