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

Search syntax for text fields (exclude)

Klara Stursova

Hello,

I would need to exclude all tickets containing the text "UAT" from the search. So I need to find the opposite of the ~ sign. I searched this help but everything I tried didn't work.

Result 1: List of valid operators.

Snímek obrazovky 2022-08-30 092043.png

Result 2: Operator not supported by field "text"

JIRa 1.png

Do you have any advice about this?

Thank you

Klara

Accepted answers

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

I'm afraid there's no direct way to do this. The ! operator is a negative search, which are hard to do, and incredibly resource intensive, so it can only be used to negate the more simple searches. With a negative search, you have to build a list of all the possible results and then subtract any you find that match the positive part of the search. It's not quick.

You could however set up a system that would enable something like your search.

Run a filter for simply "text ~ UAT". Use bulk-edit to add the label "UAT" to them all. Now you can run:

resolution = unresolved and (labels not in ("UAT") or labels is empty)

You will probably want to automate updates too - maybe run the search for UAT regularly, adding and removing the label if it has changed.

Rigo Ewen

Hi Klara and welcome to the community,

you could try to create a filter with "text ~ UAT", save it and then use it like "filter not in ("filtername")

as described here:

https://community.atlassian.com/t5/Jira-Core-Server-questions/Search-for-issues-that-do-not-contain-text/qaq-p/455633

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

You could however set up a system that would enable something like your search.

Run a filter for simply "text ~ UAT". Use bulk-edit to add the label "UAT" to them all. Now you can run:

resolution = unresolved and (labels not in ("UAT") or labels is empty)

You will probably want to automate updates too - maybe run the search for UAT regularly, adding and removing the label if it has changed.

Rigo Ewen

Hi Klara and welcome to the community,

you could try to create a filter with "text ~ UAT", save it and then use it like "filter not in ("filtername")

as described here:

https://community.atlassian.com/t5/Jira-Core-Server-questions/Search-for-issues-that-do-not-contain-text/qaq-p/455633

Klara Stursova

Thank you Rigo! This answer helped me solve the problem.

Klara Stursova

Hello Nic, thank you for the suggestion. As I am not owner of the JIRA tickets, I cannot add labels to the tickets. Otherwise this will indeed be possbile a solution.

Hannes Obweger - JXL for Jira

Hi @Klara Stursova

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would also work easily in the app that my team is working on, JXL for Jira.

JXL is a full-fledged table/spreadsheet view that allows viewing, inline-editing, sorting and filtering by all your issue fields. As text filtering in JXL uses a different technology than JQL, you can perform logical combinations of search terms, including NOT.

This is how this looks in action:

I'm showing only a small data set here but this works for any number of issues. Once you've narrowed down your set of issues, you can work on them directly in JXL, trigger various Jira operations, or export them for further processing.

Hope this helps,

Best,

Hannes

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

filter