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