JIRA Automation: Group qualifying Last Comments by their ages

[Colin_Turner]

Hi all! 

Goal: send different Slack messages based on the age of qualifying "Last Comments"

Ex: I add a comment with the keyphrase "PLS_ESCALATE" to items. I want to receive different messages around the time that comment hits ages of 24h, 48h, and 72h, respectively -- if at that time it's indeed still the last comment. 

My current design is to use a "scheduled" trigger running regularly, looking for items with a qualifying last comment, then bucketing them into age intervals to report differently. 

I've got the first part working, but can't find a component+smartvalue pairing to do the second part. Is this a case for advanced branching? If/Else? It's hard to know, because I have no last-comment date analysis working anywhere yet -- not for "issue.last.comment.created" nor for Last Comment.created -- so I am going in circles.

Can anyone advise on how to judge the age of the last comments in JIRA Automation?

Edit: bummer: rubber-duck-debugging style, I see now that it's "comments" in the smartvalues, not "comment" 🤦‍♂️, so I may make some progress again, but any advice still appreciated

[Bill Sheboy · Accepted solution]

Hi @Colin_Turner 

You seem to have the smart value expression's attributes out of order.  Please try this to find the age of the last comment added in hours using the diff() function: 

{{issue.comments.last.created.diff(now).hours}}

If that does not help, please post the following for more context:

* what type of project is this (e.g., company-managed, team-managed, JPD, etc.), 
* an image of your complete automation rule in a single image,
* images of any relevant actions / conditions / branches,
* an image of the audit log details showing the rule execution, and
* explain what is not working as expected and why you believe that to be the case.

Kind regards,
Bill