Hi @AndersBGS
Not sure if this's late for you. It's been a marathon of long days lately.
There you go!
Business Rule Before Insert/Update/Delete
Order: 9999 (last execution)
Conditions: Type is Formula
(function executeRule(current, previous /*null when async*/ ) {
if(current.operation() === 'delete'){
deleteContributors(current.getUniqueValue(), '');
return;
}
var contributors = SNC.PAFormula.getIndicators(current.formula.toString());
deleteContributors(current.getUniqueValue(), contributors);
if(gs.nil(contributors)){
return;
}
contributors = contributors.split(',');
for (var i in contributors) {
insertContributors(current.getUniqueValue(), contributors[i]);
}
})(current, previous);
function insertContributors(formula_indicator, contributor) {
var gr = new GlideRecord('u_formula_contributor');
gr.addQuery('u_formula_indicator', formula_indicator);
gr.addQuery('u_contributing_indicator', contributor);
gr.query();
if (gr.hasNext()) {
return;
}
gr.initialize();
gr.setValue('u_formula_indicator', formula_indicator);
gr.setValue('u_contributing_indicator', contributor);
return gr.insert();
}
function deleteContributors(formula_indicator, contributors) {
var gr = new GlideRecord('u_formula_contributor');
gr.addQuery('u_formula_indicator', formula_indicator);
gr.addQuery('u_contributing_indicator', 'NOT IN', contributors);
gr.query();
gr.deleteMultiple();
}
The reason for choosing a Before rule is primarily due to the delete case. After deletion, we're unable to retrieve associated contributor records.
You may consider having an After rule for Insert/Update and another Before rule for Delete (or Cascade configuration or some other around).
Cheers,
Tai Vu
