How can I display all tickets if Impact and Urgency have no value yet?

[Konstantin Löscher]

Hello,

I have the problem that I would like to filter my tickets, I want a filter in which all tickets appear that have no assignment impact and urgency.

It doesn't work with != or not in , anyone have a suggestion?

Best regards

[Nic Brough -Adaptavist- · Accepted solution]

You're looking for empty fields (ones with nothing set), so I'd suggest either

Impact is empty and Urgency is empty

Impact is empty or Urgency is empty

The first will find issues where both are unset, the second issues where either is unset.

[Alex Koxaras _Relational_]

Hi @Konstantin Löscher 

Can you please share you full JQL with us?

In addition, can you please clarify what type of fields are Impact and Urgency and what values do they take?

Finally can you confirm that at least 1-2 issues have values on these fields?

Alex

[Konstantin Löscher]

(Impact != "Extensive / Widespread" OR Impact != "Minor / Localized" OR Impact != "Moderate / Limited" OR Impact != "Significant / Large") AND (Urgency != Critical OR Urgency != High OR Urgency != Low OR Urgency != Medium)

all will be displayed that has no value in both fields

[Konstantin Löscher]

Thank You,

Impact is empty or Urgency is empty

Thats is the solution