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

Muhammad Aqib
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 5, 2024

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

1 answer

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 5, 2024

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 5, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 5, 2024

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".

Like Muhammad Aqib likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events