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 filter with sender e-mail domain name

Kristina Kivisild

I need to take out from a project by description and by sender e-mail domain name. As there is different persons who are sent the mail to us.

have tried : project = project1 AND description ~ "word 1" AND "Sender E-mail" ~ domain1.com

this get's only empty results.

Accepted answers

Ulf Johansson

Issue with ~ in jql applies for us also.

I'm running on JSW 9.1.0 data center
My use case is with a custom field typed as text field single line, I suppose same applies for multi line.

We have value in custom field TextField name,name@domain.com
Jira render value to be an email address, not plain text.

jql with ~ as in these examples:
TextField ~ domain.com - do not work
TextField ~ "domain.com" - do not work
TextField ~ domain - do not work
TextField ~ "domain" - do not work

TextField ~ "name,name@domain.com" - works

Conclusion:
When Jira type a text as email address the text value is not searchable within the email address it self.
This is a big weakness in Jira, and I will vote for a solution in https://jira.atlassian.com/browse/JRASERVER-61425

All comments

Jack Brickey

Hi @Kristina Kivisild , I am not aware of "Sender E-mail" field. Maybe that is some custom field or maybe something available in Server?

Bharathi

Hi @Kristina Kivisild

Can you confirm if the "Sender E-mail" is a custom field(probably a text field) with values including the name and domain name of users?

If yes, you can try querying it the same way. If no, I'm scared that you'll not be able to query it this way directly in the UI.

Thanks!

Kristina Kivisild

Hi!

Yes, this is custom field as text field.

But it gives in query empty answer.

Kristina Kivisild

Yes, this is custom field. Guess it's not possible to get the results this way.

Bharathi

Can you help me with a sample value of that field? Based on it, we can determine if it can be searched that way or not.

Jack Brickey

Can you try searching solely on the custom field where you know it would return an issue, e.g.

"Sender E-mail" ~ domain1

If it is a text field you should be able to search the contents using ~

Ulf Johansson

Issue with ~ in jql applies for us also.

I'm running on JSW 9.1.0 data center
My use case is with a custom field typed as text field single line, I suppose same applies for multi line.

We have value in custom field TextField name,name@domain.com
Jira render value to be an email address, not plain text.

jql with ~ as in these examples:
TextField ~ domain.com - do not work
TextField ~ "domain.com" - do not work
TextField ~ domain - do not work
TextField ~ "domain" - do not work

TextField ~ "name,name@domain.com" - works

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server