Well, of course the query can't work like this. You are looking for property
mgnl:template that exists on Metadata subnode and for the date property that
exists on the node itself. What you need there is (in xPath):
/jcr:root/demo-project[1]//*...@mgnl:template = 'stkEvent' and @date >
xs:dateTime('2009-12-31T00:00:00.000Z') and (MetaData/@mgnl:template eq
'myTemplate')]
afaik you can't do the same with the SQL since SQL search doesn't support child
axis.
HTH,
Jan
On Jul 26, 2010, at 2:07 PM, [email protected] wrote:
> select * from nt:base where mgnl:template='stkEvent' and jcr:path like
> '/demo-project/%' and date > TIMESTAMP '2009-12-31T00:00:00.000Z'
>
> Yeah I tried that before sending the initial email. Doesn't work.
>
> Rich Gange
> Systems Analyst II, ISD
> Manatee County Government
> (941) 748-4501 Ext. 3918
>
>
> From: Jan Haderka <[email protected]>
> To: "Magnolia User-List" <[email protected]>
> Date: 07/24/2010 03:39 AM
> Subject: Re: [magnolia-user] event query based on a date range
> Sent by: <[email protected]>
>
>
>
>
> ... AND date > TIMESTAMP '2009-12-31T00:00:00.000Z'
>
> Cheers,
> Jan
>
> On Jul 23, 2010, at 2:09 PM, [email protected] wrote:
>
> I'm trying to write an sql query to get all events within a certain date
> range. So far I have a query to get all events:
>
> select * from nt:base where mgnl:template='stkEvent' and jcr:path like
> '/demo-project/%'
>
>
> When I run this query one of the events returned, for example, is the New
> Year's Eve event:
>
> - <sv:node sv:name="new-year-s-eve" xmlns:sv="http://www.jcp.org/jcr/sv/1.0";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
> - <sv:property sv:name="jcr:primaryType" sv:type="Name">
> <sv:value>mgnl:content</sv:value>
> </sv:property>
> - <sv:property sv:name="jcr:mixinTypes" sv:type="Name">
> <sv:value>mix:lockable</sv:value>
> </sv:property>
> - <sv:property sv:name="jcr:uuid" sv:type="String">
> <sv:value>627e44d9-b582-4798-82e6-69f1759ce896</sv:value>
> </sv:property>
> - <sv:property sv:name="abstract" sv:type="String">
> <sv:value>This is the abstract of an event-page. It is a brief résumé on the
> content of this page. The abstract on the beginning of a page is also used in
> teasers and openers that reference this page. Li Europan lingues es membres
> del sam familie. Lor separat existentie es un myth.</sv:value>
> </sv:property>
> - <sv:property sv:name="date" sv:type="Date">
> <sv:value>2009-12-31T14:00:00.000Z</sv:value>
> </sv:property>
> - <sv:property sv:name="dateEnd" sv:type="Date">
> <sv:value>2010-01-01T05:00:56.000Z</sv:value>
> </sv:property>
> - <sv:property sv:name="eventTitle" sv:type="String">
> <sv:value>Basels most famous New Year's Eve</sv:value>
> </sv:property>
> - <sv:property sv:name="hideInNav" sv:type="Boolean">
> <sv:value>false</sv:value>
> </sv:property>
> - <sv:property sv:name="image" sv:type="String">
> <sv:value>upload</sv:value>
> </sv:property>
> - <sv:property sv:name="imageLocation" sv:type="String">
> <sv:value>above</sv:value>
> </sv:property>
> - <sv:property sv:name="link" sv:type="String">
> <sv:value>http://www.magnolia-cms.com</sv:value>
> </sv:property>
> - <sv:property sv:name="linkTitle" sv:type="String">
> <sv:value>New Year's Eve</sv:value>
> </sv:property>
> - <sv:property sv:name="location" sv:type="String">
> <sv:value>Marktplatz</sv:value>
> </sv:property>
> - <sv:property sv:name="title" sv:type="String">
> <sv:value>New Year's Eve</sv:value>
> </sv:property>
>
> The event has a date property: sv:property sv:name="date". How can I
> incorporate that into my query.
>
> Basically, give me all the events that occur after 2009-12-31T00:00:00.000Z
>
> Thanks
>
> Rich Gange
> Systems Analyst II, ISD
> Manatee County Government
> (941) 748-4501 Ext. 3918
>
>
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <[email protected]>
> ----------------------------------------------------------------
>
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
