Re: [magnolia-user] jcr query problem: filter by date range

[Ralf Hirning]

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

Ralf

Ruben Reusser schrieb:


on 3.5.4, I tried to do a query that returns only pages modified after 
a certain date:

select * from mgnl:metaData where jcr:path like '/%' and  
mgnl:lastmodified > '2009-01-01'  order by mgnl:lastmodified

this however returns all nodes instead of no nodes. Am I doing 
something wrong here?

thanks

Ruben

----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------


----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------