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