We're exploring having our Demand Assessments trigger when the demanding state moves to Submitted instead of Screening in order to better match our internal procedures.
I'm hoping someone can validate my work hear and make sure I'm not overlooking something. Our Demand states are OOB. Here are the state values for quick reference:
| Value | Label | Sequence |
| 1 | Draft | 1 |
| 2 | Submitted | 2 |
| 3 | Screening | 3 |
| '-4 | Qualified | 4 |
| 5 | Incomplete | 5 |
| 10 | Deferred | 6 |
| 7 | Rejected | 7 |
| 8 | Approved | 8 |
| 9 | Completed | 9 |
I believe this can be done by modifying the checkAndUpdateDemandIfAssessmentsComplete function in the DemandUtils script include in the following way.
Original:
checkAndUpdateDemandIfAssessmentsComplete : function(instanceSysId) {
var gr = new GlideRecord('asmt_assessment_instance_question');
gr.addQuery('instance', instanceSysId);
gr.query();
if (gr.next()) {
var questionGR = new GlideAggregate('asmt_assessment_instance_question');
questionGR.addQuery('source_id', gr.getValue('source_id'));
questionGR.groupBy('instance');
questionGR.query();
while (questionGR.next()) {
if (!(questionGR.instance.state == 'complete' || questionGR.instance.state == 'canceled'))
return false;
}
// All assessments completed
var demandGR = new GlideRecord('dmn_demand');
if (demandGR.get(gr.getValue('source_id')) && demandGR.state == 3) {
demandGR.state = -4;
demandGR.update();
}
return true;
}
return false;
},
Modified:
checkAndUpdateDemandIfAssessmentsComplete : function(instanceSysId) {
var gr = new GlideRecord('asmt_assessment_instance_question');
gr.addQuery('instance', instanceSysId);
gr.query();
if (gr.next()) {
var questionGR = new GlideAggregate('asmt_assessment_instance_question');
questionGR.addQuery('source_id', gr.getValue('source_id'));
questionGR.groupBy('instance');
questionGR.query();
while (questionGR.next()) {
if (!(questionGR.instance.state == 'complete' || questionGR.instance.state == 'canceled'))
return false;
}
// All assessments completed
var demandGR = new GlideRecord('dmn_demand');
if (demandGR.get(gr.getValue('source_id')) && demandGR.state == 2) {
demandGR.state = 3;
demandGR.update();
}
return true;
}
return false;
},
Additionally, I believe we would need to modify the Create OnDemand Assessment business rule trigger Condition.
Original:
previous.state == 2 && current.state == 3
Modified:
previous.state == 1 && current.state == 2
