How to query multiple tables via one GlideRecord

[amitroy]

Hi All,

I have a requirement where a custom field 'Row/Rack location' which extends from the 'cmdb_ci' table needs to be updated on 26 different classes. Currently a Transform map is configured on one target table - cmdb_ci_hardware where it updates the row/rack location field to only this target table.

The requirement is to update around 26 different classes. There is no such mapping exists on those 26 tables.

Is there a way to include more classes on 1 transform map? Can we built a scrip (OnBefore) to customize the mapping?

[amitroy]

Can I use a system property instead or something like this? Creating a table or something?

[amitroy]

Can I also refer a table in the OnBefore Transform script?

[Joshwa Antony S · Accepted solution]

Yes you can. Try it out.

Create a property and store values (tables/classes)

example: incident,problem,change,sc_req_item // mention your classes here

var table = gs.getProperty("YOURPROPERTYNAME HERE").split(","); //this convert the comma separate string to array 

for(var i=0; i<table.length; i++){ // this will iterate based on number of table

var gr = new GlideRecord(table[i]);
gr.newRecord();
gr.short_description = 'TEST';
gr.insert();

}

Regards,

JAS

[jyoti5]

It is working.. thank you