Schedule Job to close Non Prod Changes 7 days after moving to Review State

[nameisnani]

Hi Team ,

can anyone please help me on this requriment .

In change request table there is filed called ' Used For ' .

Where Used For is not Production - Close changes that have been in Review State for more then 7 days, then schedule a job to close these changes automatically after they have been in Rview state for 7 days

can anyone please help me on this requriment with steps .

if possible please provide screenshots for better understanding .

Thanks!

@Ankur Bawiskar 

[Dr Atul G- LNG]

Hi @nameisnani 

You can use the Flow designer. Here is basic, you can enhance it.

Trigger : Daily

Lookup records where:

• Review state is more than 7 days

• Used for = Non-prod

Action:

• Update the record

• Set state = Closed

[nameisnani]

hi @Dr Atul G- LNG  

could you please if there is any error in my flow . 

 @Dr Atul G- LNG 

Please let me know if there is any error in below conditions 

[Ankur Bawiskar]

@nameisnani 

looks good

when you tested did it not close CHG?

Also remember there might be some mandatory fields via data policy on CHG table when you move state to close

Please set those as well in Update Record flow action.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

HI @nameisnani 

There is no error. Now, do one thing: try to run these conditions at the list view and see if you’re getting the changes or not. If yes, then it must work in the flow; otherwise, there is an issue with the condition.