On Feb 26, 2008, at 12:28 AM, Ralf Hirning wrote:
Hi Ruben,
you have to specify the date as
xs:dateTime('2009-01-01T00:00:00.000+01:00')
so your query should look like this
select * from mgnl:metaData where jcr:path like '/%' and
mgnl:lastmodified > xs:dateTime('2009-01-01T00:00:00.000+01:00')
order by mgnl:lastmodified
Just as a side note, is there a performance benefit to optimizing
Jackrabbit queries? It would seem that re-arranging those so that the
most selective query (the modification date) was before the jcr path
query would be faster.
Ryan
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
