Greetings, everyone. I'm trying to call a script include from a business rule, and return a value to the BR to use in updating a record. My goal is to search for the value of a field (in this case "u_ad_department" in the sys_user table) in a table that contains aliases and a "normalized" value. Then, I want to update another field (in this case the department field in the sys_user table) with the "normalized" value. Here's what I've got so far:
The BR is:
var gr = new ABCNormalization();
gr.getNormalization(current.u_ad_department, 'cmn_department', 'DEPARTMENT');
current.department = answer;
And the script include is:
var ABCNormalization = Class.create();
ABCNormalization.prototype = {
initialize: function() {
},
getNormalization: function(alias, table, label) {
var tableID = '';
var grTable = new GlideRecord('sys_db_object');
grTable.addQuery('name', table);
grTable.query();
while (grTable.next()) {
tableID = grTable.sys_id;
}
var returnText = 'NOT NORMALIZED ' + label;
var grAlias = new GlideRecord('u_abc_normalization_aliases');
grAlias.addQuery('u_alias', alias);
grAlias.addQuery('u_table', tableID);
grAlias.query();
while (grAlias.next()) {
returnText = grAlias.u_normalized_value.getDisplayValue();
}
return returnText;
},
type: 'ABCNormalization'
};
Calling the Script Include works, and the Script Include itself works (I've sprinkled a few gs.log statements throughout). But, I can't get the value I want to come back to the Business Rule so that I can use it.
Can anyone point out where I've wandered off the ranch?
Thank you!
-Tim.
