Scripted Related Lists are different from related lists in that queries to the related tables are performed by the script.
These lists can be configured via the Scripted Related Lists (sys_related_list_script) table.
To set up a scripted related list, please complete the steps below:
- Navigate to System Settings → Scripted Related Lists.
- Click New and fill in the form.
- Click Save or Save and Exit to apply changes.
Relationships form fields
| Field | Mandatory | Description |
|---|
| Name | Y | Relationship name displayed in the list. |
| Apply to | Y | Specify the table on the forms of which this related list will be displayed. |
| Query From | Y | Specify the table containing the source records for this list. |
| Query With | Y | In this field, you can put down a script specifying the records to include from the table processed by this relationship. |
In your scripts, you are free to use current and parent objects. The main purpose of this script is to generate a query that will be applied to the table specified in the Query From field.
