I have a automation rule that uses a scheduled trigger. How to use if it was commented or not?

[Sonya Bright]

I am writing a rule that uses a scheduled trigger to run a search every x days. The rule is then supposed to trigger an email alert if the issues status is not done and if there was no comment in the last y days. The current line I have is "status != Done AND lastComment NOT IN -1d" it says that that lastComment does not exist and I am trying every combination to figure out how to make the rule run as wanted.

[Petter Gonçalves]

Hello Sonya,

Welcome to Atlassian community!

By default, JIRA Software does not have a feature that provides the kind of automation you mentioned, so I believe you are using a third-party app like Automation for JIRA Cloud. Is it correct?

Can you please let us know what app you are using? If you are not sure, please provide us a screenshot of how you configured it.

Anyway, JIRA does not have a field or parameter which store the last comment added to an issue and supports history search, so I believe there is no automation based on JQL that could get this value.

That been said, you have two options:

1 - Use the Updated parameter

You can use this to query for all issues that were not updated in a range of time:

status != Done AND updated <= startOfDay(-1)

P.S: The updated field value will be updated not only when comments are added, but also when any change is performed in the issue like status transitions, field update or log work.

2 - Use an App to increment the JQL functionality and provide the history search in the last comment.

JQL extensions for JIRA App provide the parameter CommentedOnDate which gives you the JQL you need:

commentedOnDate <= startOfDay(-1)

Let me know if this information helps.