Hi, In case this is of use to anyone, this page does query translation:
http://people.apache.org/~mreutegg/jcr-query-translator/translator.html Chris -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: 27 February 2008 18:49 To: [email protected] Subject: Re: [magnolia-user] New - XPath sorting On Feb 27, 2008, at 9:51 AM, Mike D. Jones wrote: > Since we're on the subject of XPath (or SQL for that matter), does > anyone know how to sort on an ancestor node? So, if I have a node > path, such as: > > /website/articles/title-of-article/articles/0/categories/0/@category > > Here's the Xpath that I want to work. > > //articles//element(articles,mgnl:contentNode)/*[xs:dateTime > (10/9/2007) <= @startDate]/[EMAIL PROTECTED]'ckiis009320dkeis-39820'] > order by @startDate descending > > In essence, this pulls all the article nodes less than the date > with the appropriate category. > > /articles/article1/articles/0/categories/0 > /articles/article2/articles/0/categories/01 > > Unfornately, the sort descending doesn't work. I think it's > because the context node is the child category node, not the node > (articles) where startDate is an attribute. > > If you know how to make this work via SQL I'm happy to use that > instead! > > Thanks in advance! > > Mike D. Jones I can't help much with the first query - but as a general comment about the SQL vs Xpath query... Jackrabbit translates both queries into their abstract query language before processing them. It has a mechanism inside of jackrabbit to take an abstract query and spit it back out as either an SQL or Xpath query - and in their documentation they mention that it is useful to view the other version of a query... Perhaps we could tweak the JCR Query module to have a checkbox or something that says "output detailed query information before results" that would instruct it to dump out both the xpath and sql version of the query that Jackrabbit is using to the results window. Or maybe a separate tool on that same query page that you could use to do the query translation. Ryan ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ---------------------------------------------------------------- <DIV><FONT size="1" color="gray">This e-mail and any attachments may contain confidential, copyright and or privileged material, and are for the use of the intended addressee only. If you are not the intended addressee or an authorised recipient of the addressee please notify us of receipt by returning the e-mail and do not use, copy, retain, distribute or disclose the information in or attached to the e-mail. Any opinions expressed within this e-mail are those of the individual and not necessarily of Diamond Light Source Ltd. Diamond Light Source Ltd. cannot guarantee that this e-mail or any attachments are free from viruses and we cannot accept liability for any damage which you may sustain as a result of software viruses which may be transmitted in or with the message. Diamond Light Source Limited (company no. 4375679). Registered in England and Wales with its registered office at Diamond House, Harwell Science and Innovation Campus, Didcot, Oxfordshire, OX11 0DE, United Kingdom </FONT></DIV> ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
