nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Lisa Forstberg_o85gu4

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

All comments

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"

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.