AnsweredAssumed Answered

Creating a lookup filter not based on the Select Statement

Question asked by BeckyHilton on Apr 24, 2013
Latest reply on Apr 26, 2013 by Dave
I'm trying to create a dynamic lookup with parameters in the where clause that I can use to limit the amount of data displayed. It needs to be in the where clause but not the select statement. But when I add it to the query I don't always see it in the Browse Window tab but I do see it in the Auto Suggest. I was trying to figure out if it was dependant on where in the where statement I put it like for example if it needed to be before the @Filter@ but that doesn't seem to be the case. Also when I could periodically get it to show up because it has a couple of times it doesn't actually limit the results that are displayed it still shows all of them. Is this not how it the lookups function?

SELECT @SELECT:PRJ_RES.PRID:PRID@,
@SELECT:PRJ_RES.PRUID:UNIQUE_CODE@,
@SELECT:SRM_RES.FULL_NAME:PRNAME@,
@SELECT:z_single_lookup ('CISCO_ROLE_CATEGORY', cr.cisco_role_category, 'en'):role_category@,
@SELECT:z_single_lookup ('CISCO_ROLE_GROUP', cr.cisco_role_group, 'en'):role_group@,
@SELECT:z_org_lookup ('resource', SRM_RES.id, 'cisco_role_org'):role_org@
from srm_resources SRM_RES
join prj_resources PRJ_RES on SRM_RES.id = PRJ_RES.prid
join odf_ca_resource cr on SRM_RES.id = cr.id
WHERE PRJ_RES.PRISROLE != 0
AND PRJ_RES.PRID = SRM_RES.ID
AND @WHERE:SECURITY:RESOURCE:PRJ_RES.PRID@
@BROWSE-ONLY:AND SRM_RES.is_active=1:BROWSE-ONLY@
and srm_res.full_name = @WHERE:PARAM:USER_DEF:STRING:full_name@
AND @FILTER@

Outcomes