jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sbarriba" <sbarr...@yahoo.co.uk>
Subject SYSDATE() or NOW() concept in JCR query?
Date Thu, 06 Nov 2008 10:59:23 GMT
Hi all,

We want to be able to query a set of nodes that have a date property which
is earlier than the current date.

 

Is there a function facility within JCR SQL or XPath which will be replaced
with the current time/date?

 

I can do it by creating a literal date in Java to achieve.

xpathquery "/jcr:root/home/entries//element(*,
acm:BlogEntry)[@acm:publishdate <
xs:dateTime(\'2008-11-05T00:00:00.000+01:00\')]"

 

.but I'd rather simply do..

xpathquery "/jcr:root/home/acmenodes//element(*,
acm:BlogEntry)[@acm:publishdate < sysdate()]"

 

All help appreciated.

Regards,

Shaun

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message