Need help with a JQL query

Ryan Wolfe

Hello, we are in need of seeing if tickets have been commented or had a status change that are still open in the last 30o days, but we can't seem to get it to work. Here is what I have right now:

project = DESK AND statusCategory IN ("To Do","In Progress") AND ((commentedOn < -30d AND commentedBy != assignee ) AND statusCategoryChangedDate < -30d) order by created DESC

Unfortunately, we are still getting tickets that have been commented by the assignee less than 30 days or had a status change less than 30 days ago.

We need help constructing the query so that it won't include tickets it shouldn't. Here are the criteria:

1. We need all tickets that have not had specific activity for 30 days or more
2. Activities:
   1. Reply to customers by the assignee of the ticket
   2. status change
3. The tickets must be in an open status and not completed

Any help would be greatly appreciated. We do have Scriptrunner if that is required for this search but we would prefer if we could use vanilla JQL if possible. Thanks.

Jim Knepley - ReleaseTEAM

Hi @Ryan Wolfe 

Yours might be valid, but I've always used a different syntax for date comparisons like that. Maybe try:

project = DESK AND statusCategory IN ("To Do","In Progress") AND ( (commentedOn after -30d AND commentedBy != assignee ) AND statusCategoryChangedDate after -30d ) order by created DESC