Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to Search for a ticket without an internal review date with JQL

Matt Torr February 13, 2024

Hi All,

I was hoping someone could assist me, I am trying to write a filter to search for tickets created > 6 months ago AND do not have an internal review date attached.

 

Currently, my query reads:

project = ESD AND "Internal Review Date[Date]" = "blank" AND created <= -24w order by created DESC

However, I know something is wrong with the AND "Internal Review Date[Date]" = "blank" section as I get the error "Date value "blank" is invalid.

 

If someone could help that would be great.

KInd Regards,

 

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 13, 2024

Hi Matt,

Try "is empty" instead of "= blank"

Matt Torr February 13, 2024

Hi Nic,

Yes that works thank you!

Like Nic Brough -Adaptavist- likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events