Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
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.
...
| Info |
|---|
|
...
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 |
...
. |