Risk and Impact Assessment for Change Management

[KeithM1]

I'm working on setting up the Risk and Impact Assessment for a customer.  I've got it working  where it is required before the change moves to the Assess state.  Where I'm running into a problem is if the change gets reset (i.e. moves from Assess or Authorize back to New) now when the user clicks on Request Approval, it doesn't prompt for the Risk and Impact Assessment to run again.  The customer wants it to be prompted to fill it out again.  Here's my BR to prompt for the Risk and Impact Assessment initially:

When: Before-Update

Condition:  State Changes to Assess

var assessmentinstance = new GlideRecord('asmt_assessment_instance');
assessmentinstance.addQuery('task_id', current.sys_id);
assessmentinstance.query();
if(!assessmentinstance.next())
{
current.setAbortAction(true);
gs.addInfoMessage('Please complete the Risk/Impact Assesment before requesting approval');

I'm open to any suggestions.  Thanks for everyone's input in advance

[Mike_R]

Maybe clear out the Risk score when moving back to New.

Then in order to progress from new -> assess/authorize, make it required that the risk score/risk assessment is completed.

[Saurav11]

hello,

the only way i see is that you create a counter field on the form and when the count matches the number of record on assessment instance table you show the error.

So first time both will be 0 you show the error once they fill the assessment it will be 0 to 1 you increase the counter as well as that time.

Please mark answer correct/helpful based on Impact.