Visit Freshworks.com Visit Freshworks
Solved

Scheduled Workflow with Ticket Age

  • 31 August 2023
  • 4 replies
  • 119 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

4 replies

eeha0120
Rank
Userlevel 7
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 7
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
V
Rank

Hi,

 

Can you please assist me with error I get? not sure what is invalid here.
 

 

Reply


Terms of UseCookie settings