This should work as well (added node filtering in the query directly)
/jcr:root//element(*,mgnl:content)/[EMAIL PROTECTED]:lastmodified >
xs:dateTime('2008-02-26T00:00:00.000-05:00')] order by @mgnl:lastmodified
Regards
Amir
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 26, 2008 1:39 PM
> To: [email protected]
> Subject: Re: [magnolia-user] jcr query problem: filter by date range
>
> Hi Ruben,
>
> maybe it is easier to use XPATH:
>
> "//[EMAIL PROTECTED]:lastmodified >
> xs:dateTime('2008-02-01T00:00:00.000+01:00')] order by
> @mgnl:lastmodified"
>
> will do the job
>
> Ralf
>
>
> Ruben Reusser schrieb:
> > Ralf,
> >
> > thanks for the help - I tried that but it does not work - switching
> > the > to a < does not return any pages. I tried it as well
> on the demo
> > instance at magnolia
> >
> > Ruben
> >
> > 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
> >>
> >> 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
> >> ----------------------------------------------------------------
> >
> >
> > ----------------------------------------------------------------
> > 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
> ----------------------------------------------------------------
>
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
