Adding a related list for a scoped application

[sharonjanisch]

We have a scoped application to track security exceptions that are created for users.     The table for the application is extended from Task and Requested By is the field that specifies the user for whom the exception was created.

I want to add a related list to the Incident form that will display any security exception records for the caller.       I've created a relationship.   Applies to table is set to Incident.   Queries from table is set to the Security Exceptions table.   Below is what I have in the Query with but that display all the exceptions for every user - not just the current caller on the incident.     What do I have wrong here?

(function refineQuery(current, parent) {

current.addQuery('caller_id','requested_by')

})(current, parent);

[Chuck Tomasi · Accepted solution]

I was just re-reading the docs. Try switching the query around.

current.addQuery('requested_by', parent.caller_id);

[sharonjanisch]

That was it!     Thanks so much, Chuck.

[Chuck Tomasi]

I'm glad you got your question answered. Thank you for participating in the community. Please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you