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 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 27, 2008 10:36 AM > To: [email protected] > Subject: Re: [magnolia-user] XPATH and siblings > > Hi, > > Firstly I wrote down the syntax wrong in the last email, I meant > following-siblings rather than next-sibling. Sorry. > > Trying /following-sibling::untitled2 returns nothing. > //following-sibling::untitled2 returns only /untitled2 rather than it's > siblings. > > Any ideas what is going wrong here? > > Thanks for the help, > > Chris > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Sent: 27 February 2008 14:02 > To: [email protected] > Subject: Re: [magnolia-user] XPATH and siblings > > Hi Chris, > > Hi, > > > > I'm trying to get to grips with XPath, and having some problems > > understanding next-sibling and preceding-sibling. > > > > Just for a simple example, querying: untitled2/next-sibling::* > > returns: > > /untitled2/MetaData > > /untitled2/mainColumnParagraphs > > /untitled2/untitled > > /untitled2/untitled0 > > /untitled2/untitled1 > > > > This is what I would expect (and it does) untitled2/child::* to > return. > > > > > This result is perfectly good because you're querying to find a node > called "untitled2" and under this node you're getting all the siblings > > I would expect the next-sibling query to return the set of nodes on > the > > same level, and following, untitled2. So this would not include > > untitled2 in the results. > > > > What part of this have I got wrong? > > > If I have understood you're expecting the siblings of untitled2? > To do so, just do that: > > /next-sibling::untitled2 > > HTH > > CAPITAINE Harold > > > ---------------------------------------------------------------- > 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 > ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
