Summary or description

[Katherine Stevens]

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

Thanks!

[Nic Brough -Adaptavist- · Accepted solution]

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?

[Joseph Chung Yin · Accepted solution]

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