topic Re: Check for empty/null value for a date field in Alfresco Archive

Check for empty/null value for a date field

boneill — Mon, 03 Sep 2012 12:15:09 GMT

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.

Re: Check for empty/null value for a date field

billerby — Mon, 03 Sep 2012 12:25:12 GMT

It should work with
ISNULL:"cm:content"
ISNULL:"QName"

/Erik

Re: Check for empty/null value for a date field

boneill — Mon, 03 Sep 2012 23:51:30 GMT

Hi,

Thanks for that advice, it worked well.

Regards