Autoclose Change Request after 7 days from state change

PatWro
Kilo Explorer

Hi,

I have question regarding autoclosing records.

I have to autoclose change requests after 7 days after changing state to review.

Can any advise me how to achievie that?

I could check state and updated field, but it will take into consideration last update, not state update.

I can also refer to sys_history_line table, but it's not recommended.

 

Please, give me any advice if possible. Thanks in advance.

3 REPLIES 3

Sumanth16
Kilo Patron

Hi, 

 

You can configure workflow based on condition.

If state is "review" and add "Timer" activity in workflow and declare value 7 days.

 

Then add "set values" activity and assign the value of "closed complete"

 

Please mark it as helpful (or) correct if it helps.

Thanks,

Sumanth

Knight Rider
Mega Guru

Hi,

Can you simply write a After Business Rule to achieve this.

You can refer to this below OOB Business rule on Incident table

Replace your Instance Name  in the below URL

https://YOUR_INSTANCE_NAME.service-now.com/nav_to.do?uri=%2Fsys_script.do%3Fsys_id%3Dd67b8d9ec0a8011...

 

Please let me know if you have any questions!!

 

Doesn't it work with extra field 'resolved_at'. In other case, time will be counted since last update, not cstate change update.