I am trying to filter the tickets using the words in summary within a Project. But when I query for different keywords from summary in the advanced search, I am getting tickets from other projects too. How can I filter the other project?
In your jql query just add:
project = "PROJECTKEY" AND summary ~ "free text"
Replace "PROJECTKEY" with the key or name of the relevant project and "free text" with whatever keyword you want to filter on.
A direct link to the above query:
Let me know how it goes!
Hi @Robin FloodMember,
Thanks for your reply,
Please find the query in the advanced search:
project = "Project1" AND summary ~ "1" OR summary ~ "2" OR summary ~ "3" AND summary ~ "1a" OR summary ~ "2a" AND description ~ "word1" AND created >= Date1 AND created <= Date2 ORDER BY createdDate DESC
1. Project name
2. 3 keywords anyone of them should be captured
3. other 2 keywords anyone of them should be captured
But I am not getting the output.
Ah I see, when you use the "OR" operator it will not include the initial choice of project except from the first part. It basically means show me project = "Project1" AND summary ~ "1" OR show me summary ~ "2" and so on.
You need to add some brackets, like this:
project = "Project1" AND (summary ~ "1" OR summary ~ "2" OR summary ~ "3") AND (summary ~ "1a" OR summary ~ "2a") AND description ~ "word1" AND created >= Date1 AND created <= Date2 ORDER BY createdDate DESC
Hope that works out for you!
This works for me:
project = "Project1" AND (text ~ blah1 OR text ~ blah2 OR text ~ blah3)
My query happened to be extremely long, so long that the page wouldn't scroll down to see results. This is a GUI bug/issue. To see the results of my query, I had to zoom out quite a bit (50%) on the page to be able to see the lower section's small vertical scroll bar so that I could scroll through results.
Hope this helps.
Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...
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