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.
Doesn't seem to do the work in the lookup.
This is the lookup:
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
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.