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:

TypeDescription
ArrayIn 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:

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

  • No labels