Relationships are different from related lists in that queries to the related tables are performed by the script.
Relationships can be configured via the Relationship (sys_related_list_script) table.
To set up a scripted related list, please complete the steps below:
- Navigate to {your_instance_url}/list/sys_related_list_script;
- Click New, fill in the form and click Save.
Relationships form fields
| Field | Description |
|---|---|
| Name | Relationship name displayed in the list. |
| Apply to | Specify the table on the forms of which this related list will be displayed. |
| Query from | Specify the table containing the source records for this list. |
| Query with | 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.
- The current object is an object of the table where the query is created (the table specified in the Query from field)
- The parent object is a reference to the object of a table specified in the Apply to field.
In other words, the parent object is a record form specified in the Apply to field, and a current object is a list from a table specified in the Query from field.
You can use any SimpleRecord Server-Side methods as directives in the current and parent objects,
