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 | This field references to tables dictionary (the Table (sys_db_table) table). Specify the table on the forms of which this related list will be displayed. |
| Query from | This field references to tables dictionary (the Table (sys_db_table) table). Specify the table containing the source records for this list. |
| Query with | In this field |
Это таблица sys_related_list_script.
...
Надо описать обязательно объекты parent и current, потому что от них все зависит, они все делают. Скрипт может быть в принципе любым.
- Navigate to {your_instance_url}/list/sys_related_list_script;
- Click New, fill in the form and click Save.
Relationships form fields
...