The CreatorCon Call for Content is officially open! Get started here.

get columns in incident_sla using Table API

kanikag
Tera Contributor

I am using sys_db_view to get sysid of incident_sla view, then I am using sys_db_view_table with view=sysid to get tables in view which are incident and task_sla.  Now to get columns used in view for these tables I am using sys_db_view_table_field and giving view_table as sysid of table but it is empty. 

The above procedure works well for custom made view but is not giving columns detail for incident_sla, please help me understand why sys_db_view_table_field doesnt have info of columns in tables used to create view and how to get them

5 REPLIES 5

@kanikag 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader