I am trying to create a resource dynamic query where by I only what to have a certain number of users available when I create a lookup field. The code I am using is as follows and I am looking to add something into it so It only picks up a members of a securtiy group that I have created.
FROM srm_resources r, cmn_sec_users u
WHERE u.id = r.user_id
AND u.user_status_id IN (select id from cmn_lookups where lookup_type='SEC_USER_STATUS' AND lookup_code IN ('ACTIVE','LOCK'))