topic Re: Order by XPATH in Alfresco Archive

Order by XPATH

ale_carraro — Mon, 16 Jul 2007 10:43:09 GMT

Hi, I'm writing a Custom View, altering the one called Presentation Templates/recent_docs.ftlI'm looking for folders, so my XPath query is: .//*[subtypeOf('cm:folder')]it works, but it returns the content pseudo-randomly. Is there a way to get the folders ordered by Title, or Name?thanks Alex

Re: Order by XPATH

andy — Mon, 23 Jul 2007 13:39:49 GMT

Hi

Lucene queries support ordering by the SearchParameters object. XPATH supports ordering according to the extensions in the JCR 1.0 spec. The availability of this depends on the langauage selected on the call to selectNodes. I am not sure if this is exposed via the template language. You may have to check the wiki docs.

Andy

Re: Order by XPATH

ale_carraro — Wed, 08 Aug 2007 14:01:02 GMT

I did it: as explained in the freemarker guide, you can sort on sub-properties using the notation ['x','y','z'…] to do a sort by the x.y.z… property.

So getting the folders ordered by name is done in this way:

<#list space.childrenByXPath[".//*[subtypeOf('cm:folder')]"]?sort_by(['properties','name']) as child >‍