Contains operator does not show proper results in JQL filter

[Georgi Arnauchkov]

Hi,

I am unable to make the contain "~" show proper results.
I use it to search for the domain of an email in the description field.

description ~ "domain.com"

text in the description field is seen as:

text text text 'email@domain.com' text text text

No results of the above search query are shown.
However, if you use the exact email address is used in the search it shows proper results

e.g.

description ~ "email@domain.com"

Is there a way to find all tickets with emails from this specific domain?

[Lisa Forstberg · Accepted solution]

Hi @Georgi Arnauchkov ,

Welcome to the community!

With JQL you have these options:

description ~ "email@domain.com" => match as it is exact

description ~ "email@*" => will match as a wildcard * works at the end only

description ~ "*domain.com" ==> will not match I am afraid :(

I think you have run into this feature request https://jira.atlassian.com/browse/JRACLOUD-27687

More information on options here:  https://support.atlassian.com/jira-software-cloud/docs/jql-fields/

all the best

/ Lisa

[Georgi Arnauchkov]

thank you for your information.
it is sad that this feature request has not been resolved for the past 10 years ....

[Lisa Forstberg]

Agree. 

[Sravan Indukur]

Hi @Georgi Arnauchkov ,

Rather than using JQL search, switch to Basic, and add the desired custom field. In your case add description. As the field is text, a text box will come there and add the required text for search in that and click on "Update" Button.

This is solves your problem.

[Georgi Arnauchkov]

still not showing using the basic option

[Salih Tuç]

Luckily, the CONTAINS operator is coming with bunch of pretty features like wildcard (*) or exact word (with the encoded quotes) that you can see here.

You can try something like:

description ~ "*@domain.com"

[Georgi Arnauchkov]

this gives an error as * or ?  is not accepted at the beginning of the string