Check for empty/null value for a date field

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2012 08:15 AM
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
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
Labels:
- Labels:
-
Archive
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2012 08:25 AM
It should work with
ISNULL:"cm:content"
ISNULL:"QName"
/Erik
ISNULL:"cm:content"
ISNULL:"QName"
/Erik

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2012 07:51 PM
Hi,
Thanks for that advice, it worked well.
Regards
Thanks for that advice, it worked well.
Regards
