Scheduled Workflow with Ticket Age

eeha0120 wrote:

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!

michaelmartel wrote:

eeha0120 wrote:

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,

Hi,

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

Hi @Venky24,

Please remove the single quotes in the placeholder value using to test the Expression as shown below. 

Thank you!

where did the expression ticket.create_at_iso come from?  Is there a list of these specific to Freshservice??

Is there a Last Modified Date that can be used instead of ticket.created_at_iso ?

I would also like to know if there’ is a list with available expressions - and if there is a Last Modified Date variant of the ticket.created_at_iso 

There are few pages but I found some that aren’t documented at all. 

You can do trial and error but easier is to use the web request node and parser nod to get that data. 
https://api.freshservice.com/v2/#view_a_ticket