This server-side API class allows performing various operations related to tables, like table relationships.
SimpleTable()
This method instantiates a new SimpleTable object.
Example:
SimpleTable
let table = new SimpleTable('task');
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:
getParentTables
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:
getChildTables
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"}]
