Slack notification for tickets in a status for more than X time

[Sam Nicholls]

I'm trying to set up an automation via Jira rule builder. The requirements are: if a ticket has been in the 'in review' or 'code review' status for more than 2 days, then I want to send a notification to the Slack channel for the relevant team (this is only for issues on their Jira project). 

However I must have an issue with my JQL because currently all tickets that are in code review or in review are coming through with the notification, regardless of how long they've been in code review / in review.  

When I test my JQL in the rule builder, it looks correct (see screenshot below - currently 0 issues found). So i'm not sure why it's then pulling through tickets incorrectly to Slack. 

The JQL i'm using is: project = "Project Name" AND statusCategoryChangedDate >= 2d AND status = "IN REVIEW" OR status = "Code review"

Does anyone have any ideas I could try to fix this? 

[Ponnappan Ganapathiya]

I suspect with OR status = "Code Review" . if I am not wrong it is pulling all status in Code Review irrespective of the remaining JQL.

 project = "Project Name" AND statusCategoryChangedDate >= 2d AND (status = "IN REVIEW" OR status = "Code review")

Moreover, use Status in ("In Review","Code Review") instead of using OR to avoid such confusions.

[Sam Nicholls]

I will try that, thank you!! 

[Ponnappan Ganapathiya]

also try NOT status changed after startOfDay(-2d) instead of statusCategoryChangedDate >= 2d

[Aaron Pavez _ServiceRocket_]

Hi @Sam Nicholls 

Could it be a problem with the automation? The AND will run regardless of the THEN result.

You need an IF.

Can you send us a screenshot of the Slack message you are getting? is the result of the JQL?

Regards

Aaron

[Sam Nicholls]

Hi @Aaron Pavez _ServiceRocket_

Thanks for your message! The issue is that the Slack message is sending through ALL tickets that are in either the 'code review' status or the 'in review' status on the project regardless of the length of time they've been in that status - i.e. whether they've been in there 3 days or 3 hours.

It seems to be ignoring the StatusCategoryChangedDate part of the query