Yes the parent node, there might be multiple child nodes, so the one with the latest timestamp would take precedent.
One example is a discussion forum, where you have the original message in a thread as the parent, and the replies as children. The threads should be sorted by the thread with the latest reply at the top. On 13 January 2015 at 19:03, Thomas Mueller <muel...@adobe.com> wrote: > Hi, > > I don't quite understand. The query result should be the parent node, and > those should be ordered by the timestamp on which child node? There could > be multiple child nodes per result node, right? > > Regards, > Thomas > > > > On 13/01/15 05:21, "Torgeir Veimo" <torgeir.ve...@gmail.com> wrote: > >>I'm in need of ordering some node in a query based on the latest >>timestamp on one or more child nodes. >> >>This is similar to an article with comments as child nodes, where one >>would like to order the articles in a query sorted by the last >>timestamp on the comments to each article. >> >>This doesn't seem to be work using an XPATH query, with a child node >>designator as eg */@createdProperty. IS this possible to do using >>either SQL2 or by using the QOM? >> >>-- >>-Tor > -- -Tor