Related List Script - Help

[LuizM0098939804]

Hello, everyone!

I am having trouble syncing the incident table with an internal table u_escalation_control. I basically need to filter the related list; both the incident and escalation records have the field "Company", both inheriting from core_company.

The AI gave me several alternatives and codes, but it's not working. The related list pulls all records without filtering.

[Ankur Bawiskar · Accepted solution]

@LuizM0098939804 

I believe you created a Defined Relationship between RITM and Your Escalation Control table

Applies to RITM

Queries from: Escalation Control

Query With: update as this

(function refineQuery(current, parent) {

    // Add your code here, such as current.addQuery(field, value);

    current.addQuery('u_company', parent.company); // give correct company field present on escalation control in place of u_company

})(current, parent);

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[LuizM0098939804]

Thank you very much, Ankur!