AnsweredAssumed Answered

Problem Saving a Dynamic Lookup

Question asked by BeckyHilton on Apr 24, 2013
Latest reply on Apr 27, 2013 by another_martink
I've been making edits to this Dynimic lookup and everything has been fine but I just started getting this error

ODF-0001: Unable to register dynamic query lookup: Could not retrieve or register the nsql::NsqlLookupHandler::updateNsql() =>Invalid function.

I'm not sure what it means buy Invalid Function

This is the value in the function field which was saved at one point but now whenever I try to change it and hit save or just keep it the same and hit save it throws that error


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