Hello All Members,
I just started learning ServiceNow recently and trying hard to understand a problem that I am facing.
I have a staging table setup using import set option(xml) and I am trying to update a choice field type in target table(sys_user) via staging table as its not a good practice to update target table directly.
So I am using a onbefore script to update a choice field type to --NONE-- in staging table by below script when there is a blank space provided by the user in order to update existing choice field.The script is working fine i guess and I am able to see that staging table is getting updated to --NONE--, The real issue is this --NONE-- is not getting reflected in the target table field and the previous choice type is remain unchanged.
I am using custom field and defined the field in both target as well as staging table and configured the mapping using transform map too. I just want to know why the staging table choice field is not getting mapped to target table(Other fields are working fine and getting updated successfully,Its only the choice field).
Could somebody please guide what approach should be followed in this,Thanks in advance.I have attached all screenshots for reference.
var gr = new GlideRecord('sys_dictionary');
gr.addQuery('name','my staging table name');
gr.query();
while (gr.next()) {
var ele = gr.element;
var val = source.getValue(ele);
if (!gs.nil(ele)) {
if (val !== " ") {
source.setValue(ele,val);
}
else {
source.setValue(ele,"NULL");
}
}
}
