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!

[Kevin Cauchi · Accepted solution]

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

[Tuncay Senturk]

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]

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:

1. (project in (12345)) AND (issuetype = Sub-task AND FILTER NOT IN (QAorEOS)) - This returns the item
2. (filter = "BAU & Delivery") AND (issuetype = Sub-task AND FILTER NOT IN (QAorEOS)) - This DOES NOT return the item
3. 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?