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 <


.but I'd rather simply do..

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


All help appreciated.





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