How to find out if one table is among descendants of another table?

Andrii · ‎02-27-2017

Hi,

I'm looking for ServiceNow functionality that would help me in finding out if any table is a child or among descendants of another table... is there such OOTB functionality?

jagarnathn · ‎02-27-2017

var table = new TableUtils("task"); gs.print(table.getTableExtensions());

*** Script: [incident, issue, kb_submission, sysapproval_group, change_request, change_request_imac, sc_task, problem, sc_req_item, ticket, ast_transfer_order, planned_task, change_task, change_phase, sc_request]

var table = new TableUtils("task"); gs.print(table.getAllExtensions());

*** Script: [task, incident, issue, kb_submission, sysapproval_group, change_request, change_request_imac, sc_task, problem, sc_req_item, ticket, ast_transfer_order, planned_task, change_task, change_phase, sc_request]

View solution in original post

nitish99 · ‎02-27-2017

Hi Andrii,

Go to System Definitions ==> Tables and Columns ==> Select table ==> at the bottom Click UI Action Schema Map

You will be presented with a Hierarchy, and in the top you can select Show Extended Tables.

jagarnathn · ‎02-27-2017

Hi,

The below link may be provide the info you are looking for.

http://wiki.servicenow.com/index.php?title=TableUtils#gsc.tab=0

Regards,

Jagarnath

syedfarhan · ‎02-27-2017

Navigate to System Definition -> Tables and Apply filter like ''Extensible'' is ''True'' -> Which means the list of table are extended from the other table .

Same things you can apply like table Extends table is 'task' or incident.

Thanks