Team,
I am working on Normalization Data through the Guided setup. While running Update Reference qualifier, I noticed ~2k+ records need to modify manually. (Need to add condition Normalized = True to the Reference Qualifier as shown below) I also saw SNOW documentation about it. Is it possible to add this condition via script for this 2043 records? Manually adding this condition will take for ever.
If possible please help me out.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0784201
I tried it on a record "cmdb_ci_acc" as below but doesn't seems to be working.
var rec = new GlideRecord('sys_dictionary');
rec.addEncodedQuery('reference.labelSTARTSWITHcompany^name=cmdb_ci_acc');
rec.query();
while(rec.next()){
if(rec.element == 'customer'){
rec.setValue('reference_qual_condition' , 'customer=true^canonical=true^EQ' );
rec.update();
}
else if(rec.element == 'vendor'){
rec.setValue('reference_qual_condition' , 'vendor=true^canonical=true^EQ' );
rec.update();
}
}
