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

[Vishal]

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.

[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

[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]

Hi @mauricio.groth 

Thanks for your suggestion, will check the app.

Vishal

[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]

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]

Hi @Peter Van de Voorde 

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

[Peter Van de Voorde]

I'm sorry to hear that, seems like @mauricio.groth is correct and this isn't possible out of the box.