topic ftl Sorting in Alfresco Archive

ftl Sorting

jbarrett — Mon, 19 Feb 2007 18:01:32 GMT

I have a template that lists out children of a certain type. <#list space.childrenByXPath[".//*[subtypeOf('msi:event')]"] as child>Is there a way to order the results. I need to order the results by a custom property in the display. Could there be a way to do it with a Lucene query?ThanksJo

Re: ftl Sorting

kevinr — Wed, 21 Feb 2007 10:06:34 GMT

Yes you can sort using the FreeMarker built-in:


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

Replacing 'msi:myproperty' with your custom property name.

Thanks,

Kevin

Re: ftl Sorting

kevinr — Wed, 21 Feb 2007 10:27:30 GMT

I should also mention that sorting is possible using our Lucene integration - but it is not exposed in the FreeMarker API yet.

Thanks,

Kevin

Re: ftl Sorting

jbarrett — Wed, 21 Feb 2007 20:32:27 GMT

Thanks! Works great!

How would I reverse these results?

Thanks,

Josh

Re: ftl Sorting

mikef — Thu, 12 Apr 2007 11:31:34 GMT

Use ?reverse e.g.

<#list space.childrenByXPath[".//*[subtypeOf('msi:event')]"]?sort_by(['properties', 'msi:myproperty'])?reverse as child>

Regards

Mike