Create
cancel
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

Filtering Multiple keywords in Summary, but end up in pulling tickets from other projects Edited

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?

3 answers

Hello!

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:

https://YOUR-JIRA-URL.COM/issues/?jql=project%20%3D%20PROJECTKEY%20AND%20summary%20~%20%22free%20text%22

Let me know how it goes!

Hi Prabhakaran P (Infrastructure Platform),

Could you try?

project = "My Awesome Project" AND summary ~ "word1 word2"

 

 

Does it work for you?

Regards

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

4.description keyword

5.created date

6.order

 

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

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

947 views 2 22
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