Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Summary or description

What is the right JQL  for searching for 'error' in either the summary or the description of the ticket?  I need all tickets created in the last 35 days.

I tried this JQL, but it's giving me tickets in multiple projects and also created dates before the time I need.

project = SMS AND summary ~ error OR description ~ error AND created >= -35d ORDER BY key ASC


2 answers

2 accepted

3 votes
Answer accepted

Mixing AND and OR in a query is a problem for Jira because it doesn't understand what question you are actually trying to ask it is.  It can't hear the tone of voice or punctation when you ask the question out loud.  

So, it reads uninflected JQL left to right.   For you, this means that you get two sets of results

Project = SMS and summary ~ error

Description ~ error and created >= -35d

I think you probably need to tell it your inflection:

Project = SMS and ( summary ~ error OR description ~ error ) and created >= -35d

Another trick you might try though - use "text ~ error" - this searches all the text fields on an issue for the word "error", which might be more useful to you?

0 votes
Answer accepted

@Katherine Stevens  

In addition to what @Nic Brough _Adaptavist_ suggested, (you may already know) if you are searching against text fields (i.e Summary/Description etc) where against multiple words, then don't forget to enclose your search words with " or ' .

Hope this helps too.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Improving the Create Issue Experience in Jira Service Management Cloud

Hello everyone!  We are very excited to announce some much needed changes to the issue create experience in JSM (the blue "create" button) at the top of the screen.  We have just starte...

262 views 13 7
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