jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: XPath - comparing dates
Date Fri, 21 Sep 2007 15:23:00 GMT
Amir Mistric wrote:
> I am trying to compare 2 date properties to determine if the node has been modified.
> Here are the queries I tried to use:
> 
> 1. /jcr:root/www-mysite-org//element(*,mgnl:content)[MetaData/@mgnl:activated='true'
and MetaData/@mgnl:lastmodified > MetaData/@mgnl:lastaction]

jackrabbit does not support property names on both sides of a comparison. one of 
them must be a literal.

> 2. /jcr:root/www-mysite-org//element(*,mgnl:content)[MetaData/@mgnl:activated='true'
and xs:dateTime(MetaData/@mgnl:lastmodified) > xs:dateTime(MetaData/@mgnl:lastaction)]
> 3. /jcr:root/www-mysite-org//element(*,mgnl:content)[MetaData/@mgnl:activated='true'
and MetaData/xs:dateTime(@mgnl:lastmodified) > MetaData/xs:dateTime(@mgnl:lastaction)]

the xs:dateTime() function in jackrabbit only takes a string literal.

e.g. this is a valid query:

/jcr:root/www-mysite-org//element(*,mgnl:content)[MetaData/@mgnl:activated='true' 
and MetaData/@mgnl:lastmodified > xs:dateTime('2007-01-01T00:00:00.000TZ')]

regards
  marcel

Mime
View raw message