SimpleTable

This server-side API class allows performing various operations related to tables, like table relationships.

SimpleTable()

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"}]

Page tree

SimpleTable

SimpleTable()

getParentTables()

getChildTables()