This server-side API class allows performing various operations related to tables, like table relationships.
getParentTables()
This method is intended to get information about the parent tables for any table, detailing all levels of inheritance.
Return:
| Type | Description |
|---|---|
| Array | In there, an array containing the list of tables (with their sys_ids and names) parent to the table specified will return. |
Example:
let table = new SimpleTable('sys_report_chart');
ss.info(table.getParentTables());
//Info: [{"sys_id":"156636381105818096","name":"sys_report"}] |
getChildTables()
This method is intended to get information about the child tables for any table, detailing all levels of inheritance.
Return:
| Type | Description |
|---|---|
| Array | In there, an array containing the list of tables (with their sys_ids and names) child to the table specified will return. |
Example:
let table = new SimpleTable('sys_report_chart');
ss.info(table.getChildTables());
//Info: [{"sys_id":"156836096302084733","name":"sys_report_chart_pie"},{"sys_id":"156836096401430308","name":"sys_report_chart_timed_trends"},
//{"sys_id":"156636392206287762","name":"sys_report_chart_timed"},{"sys_id":"156636392003126252","name":"sys_report_chart_bar"},{"sys_id":"156836096101018153",
//"name":"sys_report_chart_timed_line"}] |