- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 10:59 AM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 08:50 AM
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 08:41 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2023 08:30 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader