JQL Filter on multiple keywords

[Marius]

Hello,

I'm trying to run a filter for all open bugs that contains in their 'description' field, two different words, Mars and 2nd word, Galaxy. If i type bellow syntax, i get no results:

project in (cosmos) AND issuetype = Bug AND status = Open AND description ~ "Mars Galaxy"

 Is there a type of query that can return only the bugs that contains both words independently, but not tied together in a string such as "Mars Galaxy"?

Does Jira v8.5.5 support such query?

Thanks

[Jack Brickey · Accepted solution]

Unfortunately not. The text searching is lacking when trying to find exact strings. In your example it would return all issue with either word anywhere in the description field. There are a number of posts on this and there is an open bug on it too.

[Marius]

thank you

[Marius]

project in (cosmos) AND issuetype = Bug AND status = Open AND (description ~ Mars AND description ~ Galaxy)

With this query, it works.

It returns all the issues with both "Mars" and "Galaxy" words inside the description field. 

[Marius]

For:

project in (cosmos) AND issuetype = Bug AND status = Open AND description ~ ("Mars", "Galaxy")

I'm getting the error:

Operator '~' does not support the list value '("Mars", "Galaxy")' for field 'description'.