Search with due date is blank and less than current date

Question

when i searched using below jql, shows empty

due IS EMPTY AND due < now()

When i run due date and blank separately its shows record, when i combine doesn't show.

due IS EMPTY - Getting records

due < now() - Getting records

when i join those 2, no records displayed: due IS EMPTY AND due < now()

is wrong with syntax or jql?

Bill Sheboy · Answer

Hi @Ramesh Krishnan

The suggestions provided to use the OR rather than the AND keyword should work, unless...there is something else incorrect in your query, such as missing parentheses around the Due Date conditions.

If so, please post the entire query you are using to provide more context.  Thank you.

Kind regards,
Bill

Ramesh Krishnan · Answer

already  i tried this also, not working

PgM Innovations Support Team · Answer

Hi @Ramesh Krishnan,

Use the query below instead:

due IS EMPTY OR due < now()

AND means both conditions should be met.

Regard,

PgM Innovations