Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

What's the best way to limit the output of a JQL when querying more than one field?

I am looking for records that were commented on a specific date but I only want the records with a specific keyword in those comments.

I tried the following JQL but it returns all records with a comment on the specific date regardless of whether the keyword I am looking for in the comments is present or absent.

     ...(commentedOn in ("2021/5/12") AND comment ~ "My keyword")...

Thanks for the feedback.

2 answers

Hi @Rosauro  -- Welcome to the Atlassian Community!

You cannot do what you ask with out-of-the-box Jira queries.  JQL isn't a generic SQL and isn't built to allow nested sub-queries. 

If you need to do this often, there are marketplace addons for purchase which could support this.  If you need this ability infrequently *and* have only a few issues to review, consider performing one of the queries first, and then manually check each resulting issue.

Best regards,


Hi Bill,

Thank you for the warm welcome!

I was beginning to reach the same conclusion as you had mentioned above while continuing to experiment with a possible solution to my issue. The manual check solution works for now - massaging the data in Excel.

Which add-ons would you recommend for me?




Hi Rosauro,

I am not currently using any of those, and you may search for them here for your server edition:

In the comments from @Vikrant Yadav they are noting a solution that would use the ScriptRunner addon with the issueFunction feature.

Best regards,


Hi @Rosauro if you search by comment, the JQL query will only search for those issues which have been commented on, which means that all the issues without comments will be ignored.

This issue is already sloved by Atlassian Team. Check out below link very helpful :-,'success%20couponscom%2Dintegration'.



Hi @Vikrant Yadav ,

Thank you for the reference to the prior post. It is very informational. However, my predicament is a little different than what it describes. Mine is centered around two things:

1. Find all records with a comment on a specific date. We have regular meetings to review JIRA records and the meeting minutes/decision for each record are captured in the comments. Thus, this is the first requirement - to look for any record that has a comment on the date of the meeting.

2. Determine if the comment on a specific date contains keywords that would indicate it was reviewed by the right team. Our records receive comments from many team members throughout the lifecycle of the record, sometime multiple comments are added daily. As such, it is imperative that I filter for a specific keyword to determine that the comment indicates it was from a meeting that I am interested in.

What I'm trying to do is basically filter the results of a prior filter result. I haven't gotten it to work so far in JQL by using AND or by sequencing the queries. Do you know of a way to feed the results of one filter/query into another? Without external plugins? :-D

Hi @Rosauro  For checking comment on a particular date, you can user below query, but it only works if you have ScriptRunner Plugin installed.


project = "JIRA Support" AND issueFunction in commented("after 2019/01/31 before 2020/01/07")



Hi @Vikrant Yadav ,

Thank you for your suggestion. It gives me an alternative to the commentedOn keyword. It is always good to know more than one way to do things.



Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Bitbucket

📣 Calling Bitbucket Data Center customers to participate in research

Hi everyone, Are you Bitbucket DC customer? If so, we'd love to talk to you! Our team wants to dive deep to understand your long-term plans regarding Bitbucket DC and Atlassian Cloud. Do you plan...

173 views 2 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you