Query changes before next CAB meeting

[jeffrey_sharpe]

I have a requirement to perform an action on changes if certain criteria is not met on changes. Whats needed is to check today at 9:00 if changes that will be implemented today are not ready for CAB to automatically reschedule them. I have that part figured out. However, included in that needs to be changes that are planned to be installed tomorrow prior to 9:00 need to be rescheduled as well. 

[Dr Atul G- LNG · Accepted solution]

Hi @jeffrey_sharpe 

Try to add one more condition

[jcmings]

How are you doing this now? Flow designer? You could achieve your ask with flow designer through the Look up records flow action (using your criteria) and a For each loop (passing in the Look up records data pill... e.g. for each record in the look up records search). Inside the for each loop, you'd do something like Update record and you can update the date.

[jeffrey_sharpe]

Currently just running a scheduled job to query changes when the meetings starts and as I mentioned it takes care of the changes for "Today" but cant capture "Tomorrow's" changes before 9.

[jcmings]

Gotcha. Can you share the script you're using? Are you open to trying a flow?

[jeffrey_sharpe]

I am open to trying a flow, however I have no experience using Flow Designer

var changegr = new GlideRecord('change_request');

changegr.addEncodedQuery('start_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^type=normal^state=-5^ORstate=-4^active=true^u_authority_approval=CAB^ORu_authority_approval=VP');

changegr.query();

while (changegr.next()) {

var count = changegr.getRowCount();

gs.info('Changenumber is ' + changegr.number);

rescheduleChange();

}

function rescheduleChange() {

new WorkflowApprovalUtils().cancelAll(changegr,"Change request is being rescheduled");

new Workflow().restartWorkflow(changegr);

new OpConflictUtils().clearConflicts(changegr.getUniqueValue());

changegr.approval="not requested";

new OP_ChangeUtil().closeAWSReq(changegr.getUniqueValue(), 2);

changegr.setValue('u_exception',false);

changegr.setValue('conflict_status','Not Run');

changegr.setValue('u_choice_2','');

changegr.setValue('start_date','');

changegr.setValue('end_date','');

changegr.setValue('conflict_last_run','');

changegr.setValue('cab_recommendation','');

changegr.setValue('u_conflict_accepted', false);

changegr.setValue('cab_date', '');

changegr.setWorkflow(false);

changegr.setValue("state", -5);

changegr.work_notes = "Change did not have the required approvals in place prior to the CAB meeting. Change has been rescheduled via automation. Please set a new Planned Window, adjust your change as needed, and re-submit for approvals.";

changegr.update();

}

gs.log('Total number of changes ' + count);