To automate state change from Scheduled to Implement

[Arun33]

Hi,

I want a change request to move automatically from Scheduled to Implement state, at the planned start date/time.

I have created a Flow to change from Scheduled to Implement state, at the planned start date/time. but in flow

Wait For Condition if not working:

In Wait For Condition I have used script in condition.

var start_date = fd_data.trigger.current.start_date;

var on_hold = fd_data.trigger.current.on_hold;

if (start_date == gs.nowDateTime() && on_hold == 'false') {

return true;

}

But this if condition is not working as expected. This if condition should be executed when planned start date/time is equal to system date/time 

can anyone help me on this

[SVPV]

Hi Arun

Wanted to understand if this works fine as per your requirement?

Regards

SVPV

[Galfordus1]

Did anyone figured out what would be the easiest way to handle the flow if start_date  / end_date changes during flow exection?
I know we could do few things, but for a simple thing like that, it seems like a little overkill to cancel the flow itself and retrigger. It would be easier to have most of the logic in one flow.

[Dr Atul G- LNG]

Changing the dates during change implementation is not as per process or best practice. 

[Galfordus1]

I understand and I agree to some extent.

But in special circumstances it might be useful. And besides, this seems like a feature that I would like to know how to best implement in case I need it for any other field change during flow execution, so for sake of knowledge would like to know how to best approach this. 

[ChaitrashreeHM]

Hello Everyone,

We can achieve this using Scheduled job run periodically

Use the below script.

var grChange = new GlideRecord('change_request');

grChange.addEncodedQuery('state=-2');

grChange.addQuery('start_date', '<=', new GlideDateTime());

grChange.query();

while (grChange.next()) {

    grChange.state = -1; // Change state to Implement

    grChange.update();

}

This works fine and state changes on proper planned start date.

Thank you.

Please mark this response as correct or helpful if it assisted you with your question.