AnsweredAssumed Answered

Restrict Lookup Results based on user rights to the custom object the lookup is based on?

Question asked by e_martin on Jun 1, 2015
Latest reply on Jun 1, 2015 by nick_darlington

We have a custom object that contains a selection of items, it's OBS enabled and we're looking to build a lookup around the custom object that allows it to only show the items from the custom object that the person using the lookup has access to within that custom object.

 

@WHERE:SECURITY:RESOURCE:RESOURCES.ID@ 

 

Doesn't seem to do the work in the lookup.

 

This is the lookup:

 

SELECT

@SELECT:GROUPS.ID:ID@,

@SELECT:CAPS.NAME:NAME@,

@SELECT:CAPS.DESCRIPTION:DESCRIPTION@

 

FROM CMN_SEC_GROUPS GROUPS

 

JOIN CMN_CAPTIONS_NLS CAPS ON GROUPS.CAPTIONS_PK_ID=CAPS.PK_ID

JOIN ODF_CA_AV_SEC_GROUPS LIST ON LIST.ATT_SEC_GROUP=GROUPS.ID

 

WHERE @FILTER@

AND @WHERE:SECURITY:RESOURCE:RESOURCES.ID@

AND CAPS.LANGUAGE_CODE='en'

AND CAPS.TABLE_NAME='CMN_SEC_GROUPS'

AND GROUPS.GROUP_ROLE_TYPE='GROUP'

AND GROUPS.IS_ACTIVE='1'

 

What we're trying to do is make a place we can put a list of security groups, and have the lookup only show the relevant ones for the user.

Outcomes