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

[Matt Torr]

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,

[Nic Brough -Adaptavist- · Accepted solution]

Hi Matt,

Try "is empty" instead of "= blank"

[Matt Torr]

Hi Nic,

Yes that works thank you!