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
