I am trying to create a JQL (where labels != "Reviewed") but the results are not returning blanks

Marie SanFilippo March 19, 2019

Any suggestions for the appropriate syntax to return null values in a field. I just don't want to review any of the results where they were already reviewed. 

2 answers

2 accepted

0 votes
Answer accepted
Warren
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 19, 2019

Hi @Marie SanFilippo 

project = GC AND status in (Approval, "Functional Test", Grooming, "In Development", "In Progress", Open, "Ready for Dev", "Regression Test") AND "Sub-Issue Type" = Performance AND (labels != Performance_Reviewed AND labels is EMPTY)

You need the last section in the brackets, then it should return all the items you're expecting

Marie SanFilippo March 19, 2019

Thank you So much!!! that worked :) 

0 votes
Answer accepted
Marie SanFilippo March 19, 2019

project = GC AND status in (Approval, "Functional Test", Grooming, "In Development", "In Progress", Open, "Ready for Dev", "Regression Test") AND "Sub-Issue Type" = Performance AND labels != Performance_Reviewed

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2019

Hi Marie and welcome to the Community!

To see null values, use the syntax of "is empty". For example, labels is empty or labels is not empty. 

Marie SanFilippo March 19, 2019

Thank you !

Suggest an answer

Log in or Sign up to answer