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; } } }

JQL doesnt not give any result for "~" operator on short text field

Vishal_p33pdz

Hello Everyone,

I have a short text field where users input email address, I am using a JQL to filter out email address for specific email domains with the operator "~" but it does not give any result.

My Query is like :

project = ABC AND Email ~ 'abc.com'

Anyone experienced similar thing earlier ? I know this works very well in Data Center but in cloud its not working.

Thank you.

Accepted answers

All comments

Peter Van de Voorde

Hey @Vishal ,

Have you tried using ~"*abc.com" so with double quotes and an asterix?

That seems to be the correct syntax based on the documentation: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CONTAINS----

Cheers,
Peter

Vishal_p33pdz

Hi @Peter Van de Voorde

Thanks for your reply.

I did try to use it but I am getting error "the '*' and '?' are not allowed as first character in wildcard query."

Vishal

Peter Van de Voorde

Can you please try "abc.com*" instead?

Vishal_p33pdz

Hi @Peter Van de Voorde

Unfortunately, it doesn't give any result either nor any error.

mauricio.groth

Hi @Vishal

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your issues whose custom field e-mail is “abc.com”.

issue in wildcardMatch("Email", "abc.com")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

Vishal_p33pdz

Hi @mauricio.groth

Thanks for your suggestion, will check the app.

Vishal

Hannes Obweger - JXL for Jira

Hi @Vishal,

I assume that this is related to how Jira does its internal indexing for full text JQL searches; unfortunately, this sometimes leads to unexpected results when searching for parts of words, or in your case, email addresses.

This being said, if you're open to solutions from the Atlassian Marketplace, you'll find several options there that don't have this limitation. E.g., this would be trivial to do using the app that my team and I are working on, JXL for Jira:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud