Transform map field script to map with sys id

_bhishek
Tera Guru

Hello All,

 

I have 2 model category with same name as Tablet device in model table and . I want to  map only one model category(reference field on model table) in model table transform map when there is import which is correct and we don't want to map with old model .Could you please help me with field script of same .I think we can map with sys ID of correct model.

Thanks.

1 ACCEPTED SOLUTION

Hello @_bhishek 

 

Sure thing,

 

First you'll need to create new system property records with a string value and set the value to the sys_id of the related model.

JoeS1_0-1683128499077.png

 

Then update your field map script to get the system property value like this:

answer = (function transformEntry(source) {

	// Add your code here
	if (source.u_model == 'Alienware M14x') {
		return 'get(sys_property)';
	}
	else if(source.u_model == 'Alienware M17x') 
	{
		return gs.getProperty('cmdb.model.sys_id.alienware_m17x');
	}
	else
	{
		var gr = new GlideRecord("cmdb_model");
		gr.addQuery("name", source.u_model);
		gr.query();
		if (gr.next()) {
			return gr.getUniqueValue();
		}
	}

})(source);

 Now this does require a property for each sys_id you need to return. So the GlideRecord query can return sys_id's but however you can't use a system property.

View solution in original post

11 REPLIES 11

@_bhishek 

yes you can store those sys_ids in system property and use gs.getProperty() to get the value and set it

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

@_bhishek 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

I believe I answered your question first by providing the approach.

If my response helped please mark it correct as well so that it benefits future readers.

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