cancel
Showing results for 
Search instead for 
Did you mean: 

Check for empty/null value for a date field

boneill
Star Contributor
Star Contributor
Hi Guys,

Does anyone know how to check using lucene query language how you check if a date field is empty or null.  My scenario is that I set the effectivity aspect on a node but use a job to then set the values based on a schedule.  So initially the cm:from and cm:to date fields will have no value.  I want the lucene query in the Scheduled Job to find all docs that have no value set for the to and from dates.  Something like @cm\:to:null.

Regards
2 REPLIES 2

billerby
Champ on-the-rise
Champ on-the-rise
It should work with
ISNULL:"cm:content"
ISNULL:"QName"

/Erik

boneill
Star Contributor
Star Contributor
Hi,

Thanks for that advice, it worked well.

Regards