I am trying to edit the query for the SCH_BROWSE_RESOURCE lookup. The current query is as follows:
FROM SRM_RESOURCES RESOURCES WHERE
@FILTER@ AND RESOURCES.PERSON_TYPE != 0
AND case when resources.user_id is null then 0 else resources.user_id end != -99
AND RESOURCES.IS_ACTIVE = 1
I am trying to add in a line that would allow us to display the resource's email address but whenever I XOG in the attached XML file it simply does not update the query.
The reason users are not able to update SCH_BROWSE_RESOURCE lookup is because it is System-restricted and not intended to be changed. You can if you like create a custom lookup using the same NSQL and make necessary change for your use case.