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

NOT (text ~ TEXT1 OR text ~ TEXT2) no longer working

Kevin Cauchi

Previously I had this query:

(project in (12345)) AND (issuetype = Sub-task AND NOT (text ~ QA OR text ~ EOS ) )

It used to pick up subtask items from project 12345 which do not have QA or EOS in the text.

Now, this is no longer working. It is not giving an error, it just does not return any values.

Was there a recent change here?

P.S. test !~ QA is an invalid syntax and removing NOT gives all items which have QA and EOS so clearly, the issue is with the NOT.

Many thanks!

Accepted answers

Kevin Cauchi

Ok I found a workaround. I am now using Summary instead of Text.. seems text is very messy in terms of implementation

All comments

Tuncay Senturk _Snapbytes_

Hi @Kevin Cauchi

It's always tricky using ~ operator and text field. I am not sure whether it even worked but I think you can use this workaround. (I believe filtering in another way e.g. label, component, custom field is more convenient though)

Run JQL : text ~ QA OR text ~ EOS and save it as a filter, name it QAorEOS (can be anything)

Then use JQL: project in (12345) AND issuetype = Sub-task AND filter not in (QAorEOS)

Kevin Cauchi

I am not sure what "filter" is referring to in that JQL, however I tried the above and it still returns QA or EOS with the rest of the items

Tuncay Senturk _Snapbytes_

Did you run the JQL and save it as a filter and ensure that you use filter not in ..

It refers to the issues which are not returned from the filter's JQL.

By the way, I tried it and it worked.

Kevin Cauchi

Yes I did.. however I tried a few things:

(project in (12345)) AND (issuetype = Sub-task AND FILTER NOT IN (QAorEOS)) - This returns the item
(filter = "BAU & Delivery") AND (issuetype = Sub-task AND FILTER NOT IN (QAorEOS)) - This DOES NOT return the item
filter = "BAU & Delivery" - This DOES return the item

It seems very inconsistent. However what happened to the how it was working before? It was working fine. Do we know if something was changed in JQL?

Kevin Cauchi

Ok I found a workaround. I am now using Summary instead of Text.. seems text is very messy in terms of implementation

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jql