Can we create table using script?

Rajan Masurkar · ‎07-11-2017

Can anyone guide me whether we can create table using script?

Mraj

navdeep_singh · ‎07-11-2017

We can create UI action and can use below scrip.

Source table is Assessment Metric

Var cat_sys_id = current.sys_id.toString();

var attrs = new Packages.java.util.HashMap();

var table_name= 'custom_table';

var fname;

var src_table = new GlideRecord('asmt_metric');

src_table.addQuery('category', cat_sys_id);

src_table.query();

while(src_table.next())

{

fname = src_table.name;

var ca = new GlideColumnAttributes(fname);

ca.setType("string");

ca.setUsePrefix(true);

attrs.put(fname, ca);

}

var tc = new GlideTableCreator(table_name , table_name);

tc.setColumnAttributes(attrs);

if(typeof extends_table != 'undefined') tc.setExtends(extends_table);

tc.update();

snehabinani26 · ‎07-11-2017

Hi Rajan,

This link have steps to create a custom table from script.

Hope this helps you

Karthik Reddy T · ‎07-11-2017

Hello Rajan,

Refer the below links may helpful to you.

Karthik Reddy T.
ServiceNow Commnunity MVP -2018 class.

navdeep_singh · ‎07-11-2017

Hi Rajan,

Yes, we can create a table by using script.

Please explain your requirement in detail.

Regards,

Navdeep

Rajan Masurkar · ‎07-11-2017

Hi Navdeep,

The requirement is columns of this table will be the records in other tables.

Mraj