Hi Raviteja,
Create a business rule on the custom table that executes on "insert".
Check on "Advanced" and add the following script. I've named fields "fuctionalarea" and added fields to enter table name, language, value, and label to set on the choice.
(function executeRule(current, previous /*null when async*/ ) {
if (current.category == '' || current.functionalarea == '' || current.subcategory == '') {
return;
}
var fieldList = ['category', 'subcategory', 'functionalarea'];
var name = current.name; // 'incident';
var lang = current.language; // 'en';
var value = current.value; // 'test';
var label = current.label; // 'test';
for (var i = 0; i < fieldList.length; i++) {
insertRecord(name, lang, value, label, fieldList[i]);
}
function insertRecord(name, lang, value, label, field) {
var grChoice = new GlideRecord("sys_choice");
grChoice.addQuery('name', name);
grChoice.addQuery('element', field);
grChoice.addQuery('language', lang);
grChoice.addQuery('value', value);
grChoice.query();
if (!checkGR.hasNext()) {
var grChoice2 = new GlideRecord("sys_choice");
grChoice2.initialize();
grChoice2.setValue('name', name);
grChoice2.setValue('element', field);
grChoice2.setValue('language', lang);
grChoice2.setValue('value', value);
grChoice2.setValue('label', label);
grChoice2.insert();
}
}
})(current, previous);
