How to mention None in a condition?

[venkatesh satish]

I want to filter all my items whose Complexity value are not assigned (for those it has value None)

[Alex Koxaras _Relational_ · Accepted solution]

Hi @venkatesh satish 

Try Complexity is empty or Complexity = null

[venkatesh satish]

I tried both, but it is not showing items which has value "None".
I mean i get no result :(

[Alex Koxaras _Relational_]

@venkatesh satish can you explain more what do you mean by "mention None"?

[venkatesh satish]

We have field called Complexity, and it can have value like A, B, C n/a.
Say suppose if we dont maintain any value for this complexity field then system would take automatic value called "None"

[Alex Koxaras _Relational_]

@venkatesh satish hold on..

So what are the values of the Complexity field? In your case the values should be:

• A
• B
• C
• None (or N/A, or something else)

Keep in mind that Jira shows a "None" value on certain CF types to indicate that the user hasn't selected any value. This value is "None". To find these value, the above JQL I mentioned would do the trick. If you however have create a value "None" on that field then the JQL should be Complexity = None

[venkatesh satish]

@Alex Koxaras _Relational_ We have values called

n/a 

Not-defined yet

But we have not maintained separate value hep called None.

I tried all possible way but none is working for me :(

[Alex Koxaras _Relational_]

@venkatesh satish share a screenshot of your field's value, as well as mark the values which you want to filter.

[venkatesh satish]

@Alex Koxaras _Relational_  I want to filter None

[Alex Koxaras _Relational_]

@venkatesh satish None is not an option you have placed. This was placed by Jira, as I explained to you previously. So Complexity is empty or Complexity = null should yield all issues with all other choices populated, meaning all issues which have all the rest values.  

[raj-kumar2]

Hi Venkatesh,

This is straight, Complexity is empty or Complexity = null should filter the issues.

Regards,

Raj