Visit Freshworks.com Visit Freshworks
Solved

Scheduled Workflow with Ticket Age

  • 31 August 2023
  • 3 replies
  • 93 views
michaelmartel
Rank
Userlevel 4
Badge +8

I want to create a scheduled workflow to run daily to do an action on tickets older than 60 days. Ticket age is not an option in Condition. Any ideas on how I can accomplish this?

icon

Best answer by eeha0120 31 August 2023, 21:40

View original

3 replies

eeha0120
Rank
Userlevel 6
Badge +11

Hi Michael.

Yes, that’s not available.

You need to use an Expression for that.

You may use (please, ensure to adapt to your time zone):

diffInDays("{{ticket.created_at_iso}}", today('America/Bogota'))

 

And then compare with that result.

 

You should end with a workflow similar to the following (adapting to your need, of course):

 

Here are the last two nodes you need:

 

 

That way, you’d be able to compare a ticket date creation against today, and perform any desired action when that value is greater to 60.

 

 

Hope this helps.

 

 

Regards,

Elvis Henriquez
michaelmartel
Rank
Userlevel 4
Badge +8

Hi Michael.

Yes, that’s not available.

You need to use an Expression for that.

You may use (please, ensure to adapt to your time zone):

diffInDays("{{ticket.created_at_iso}}", today('America/Bogota'))

 

And then compare with that result.

 

You should end with a workflow similar to the following (adapting to your need, of course):

 

Here are the last two nodes you need:

 

 

That way, you’d be able to compare a ticket date creation against today, and perform any desired action when that value is greater to 60.

 

 

Hope this helps.

 

 

Regards,

Perfect! 

Thanks!

 

 

eeha0120
Rank
Userlevel 6
Badge +11

Hi Michael.

Yes, that’s not available.

You need to use an Expression for that.

You may use (please, ensure to adapt to your time zone):

diffInDays("{{ticket.created_at_iso}}", today('America/Bogota'))

 

And then compare with that result.

 

You should end with a workflow similar to the following (adapting to your need, of course):

 

Here are the last two nodes you need:

 

 

That way, you’d be able to compare a ticket date creation against today, and perform any desired action when that value is greater to 60.

 

 

Hope this helps.

 

 

Regards,

Perfect! 

Thanks!

 

 

Anytime. Glad I could help.

 

Would you mind to please ensure to mark as Solved, so others with similar inquiries may also find this information?

 

Thanks in advance.

 

 

Regards,

Elvis Henriquez

Reply


Terms of UseCookie settings