[xwiki-users] Query a date field?

22 Feb 2008

      Hi everyone, having a small problem on an HQL query (and hope someone's
managed to get this working before)

NOTE: $dtDateToCompare is yesturdays date, generated with groovy

select obj.name
from
   BaseObject obj,
   XWikiDocument doc,
   StringProperty propnrd
where
   obj.className='XWiki.clickClass' and
   obj.name<>'XWiki.clickClassTemplate' and
   obj.name not like('%/%') and
   doc.fullName=obj.name and
   propnrd.id.id=obj.id and
   propnrd.id.name='clickDateAssign' and
   propnrd.value < '${dtDateToCompare}'
order by
   obj.name asc

This works if I use the modified date property of the document (as a test);
but not for a custom date property (propnrd.id.name='clickDateAssign' is a
date property of the class).

Anybody do something similar and can share some pointers?  Using MySQL if
that makes any difference

[xwiki-users] Query a date field?

Uncanny Manners