Custom Field Filter

We have a custom 255 text field using the Free Text Searcher that is causing troubles when building filters.

This custom field holds email address that contain the system system of @. We know that in order to use this symbol in our filter, occording to documentation, that you need to have one of the following.

NOTE: We are using !~ as a way to exclude certain tickets containing this specific field value from returning in the filter.

1."Email From" !~ "abc500@example.com"
2. "Email From" !~ abc500\\@example.com

Both of these string work...to a degree. The problem is when we use email address as a filter limiter we loose tickets in the report. These tickets do not contain the address listed, or even email addresses at all, they should be returning in the filter results. It seems that the system value of @ is making them disappear.

Ex. 5 tickets should show in results 100, 101, 102, 103, 104, 105. (correct filter not using email address as a limiter.)

Ex. 5 tickets should show but only 3 appear 100, 101, 104. ( filter when using email adddresses as a limiter.) 102 and 103 SHOULD also report but do not for some reason.

I can produce screenshots if necessary.

Thanks for the help and if possible please give a string example. I'm a visual learner :)

1 answer

I'm a visual learner too, screenshots would help. :)

I'll get some screenshots uploaded soon.

Wow, I'm a terrible person! I forgot about this question and never uploaded the images. My apologies. Today I tired to make screenshot but the filter I'm using contains personal customer information that I can't post. I'm going to type out the query lines for your example but I'll have to make some replacements.

First example query

project = "AIS: Security, Accounts, and Support" AND status = "Action Required" AND "SAS Components" = Accounts AND (summary ~ "Automated+Account+Action" OR "Email From" !~ "abc5000@example")ORDER BY updated ASC

Second example query

project = "AIS: Security, Accounts, and Support" AND status = "Action Required" AND "SAS Components" = Accounts AND (summary ~ "Automated+Account+Action" OR "Email From" !~ abc5000\\@example)ORDER BY updated ASC

The only change is the syntax. A loss of double quote for the addition of \\. These two things are suppose to be interchangeable but I get different results with each query.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,980 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot