I need help with JQL for a scenario assignee not changed by current user in a specific month

[Muhammad Aqib]

Please review the scenario
I want to filter all those tickets in a project "xyz" with status "QA" and the status changed to "QA" during ("2024-03-01","2024-03-31") and that don't have my comment "abc" and assignee was not changed by "user" during ("same date range").

how can I filter issues that don't have my comment "abc" and assignee was not changed by "user" during ("date range")

TIA

[Trudy Claspill · Accepted solution]

Hello @Muhammad Aqib 

Welcome to the Atlassian community.

and assignee was not changed by "user" during ("date range")

For that you would use this JQL:

and not Assignee CHANGED BY "user" DURING ("2024-03-01","2024-03-31")

and that don't have my comment "abc"

What attribute of the comment are you referring to when you say "abc"? Is that the comment body? If it is the comment body, is it the entire comment body or just a portion of it?

And would you include issues that have comments authored by other people that have "abc"? Or that have other comments authored by you that don't have "abc"?

Regardless, Jira doesn't have a native JQL capability to filter issues based on the author of the comments. That would require a third party app that extends JQL functionality.

[Muhammad Aqib]

Hi @Trudy Claspill 

By "abc" I meant comment body and it is portion of the comment not an entire comment.

I just don't want a comment that includes 'abc' regardless of author, like all the issues that don't have part of the comment 'abc' in a date (range) and assignee was not changed by me in a date (range).

[Trudy Claspill]

Your original post did not include anything about applying a date range to the comments you want to consider.

Jira also does not have a native JQL capability to filter issues based on the date of the comments. That would require a third party app that extends JQL functionality.

The only native filtering available for comments is to filter for issues based on the content of any one or more of their comments. If you used

comment ~ "abc"

...you would get any issue where any one or more of its comments included "abc" in the body.

If you used 

comment !~ "abc"

...you would get any issue that had at least one comment that did not include "abc", but it may also have other comments that do include "abc"

While there are third party apps that enable filtering based on the author of comments and the date of comments, I am not sure if they support combining the elements so that you could get issues where none of the comments made in a date range included "abc".