Thank you Hitoshi. I'm working on the transform script which could recognize the CI based on the name and Class value provided in data source. I need to import data to the custom table with the reference fields from another tables, like cmdb_ci (which means that cmdb_ci is not a target table).
I've managed to create the script to be able to match the correct CI from cmdb_ci table to compare with what I have in my data source. However, in my second addQuery() for sys_class_name expected value is not for instance "Windows Server", but "cmdb_ci_server". The thing is, that I would like to use the display value from the data source.
answer = (function transformEntry(source) {
var gr = new GlideRecord('cmdb_ci');
gr.addQuery('name',source.u_name);
gr.addQuery('sys_class_name',source.u_class); // This line is wrong...
gr.query();
if (gr.next()) {
return gr.sys_id.toString();
}
})(source);
In my case I cannot distinguish by any other column, unfortunately and need to specify the condition based on Class field as well along with the name.
Does anyone of you know how to define addQuery or update my script to be able to take the display values for Class column from my data source and use them in my addQuery condition? Without defining all possible Classes in my code?
Thank you in advance for help!
