topic Re: Freemarker sort_by in Alfresco Archive

Freemarker sort_by

tfpadilla — Wed, 27 Aug 2008 14:20:44 GMT

Hi everybody,I have created a custom type of documents and a custom type of folder for containig them.For showing the documents in a custom view I have created a template.I need to sort the documents by one of the custom properties but I don't know how to do it.Reading some posts I have tried with:&

Re: Freemarker sort_by

xerox — Thu, 28 Aug 2008 06:53:57 GMT

Does every child has your custom property?
If you want to sort by freemarker, be sure every child have that property.

friendly regards,

Nick

Re: Freemarker sort_by

jbarmash — Thu, 28 Aug 2008 06:55:01 GMT

are you 100% certain that each of the children of the space you are looking at has the property "fact:cuenta"?

I just tested with this little script, and it worked fine:

<#list companyhome.children?sort_by(["properties", "cm:name"]) as child>
It works
</#list>

Re: Freemarker sort_by

tfpadilla — Thu, 28 Aug 2008 08:39:27 GMT

Yes, all the documents of the space have the property.

In fact, the property is mandatory in the custom type, and this custom type is the only one that this custom space accepts.

For giving more details: the possible subspaces in this space wouldn't have the property but at the moment there aren't subspaces.

<#list space.children?sort_by(["properties", "cm:name"]) as child> also works for me but
<#list space.children?sort_by(["properties", "fact:cuenta"]) doesn't.

Could you, please, try with a property of a custom type in your system?

Thanks a lot for helping me,
Teresa

Re: Freemarker sort_by

xerox — Thu, 28 Aug 2008 08:46:29 GMT

It should work. I already used this sort option may times with custom properties.

Did you declare "fact" as prefix for your namespace?
You could try to take the whole name space name.
e.g.: <#list space.children?sort_by(["properties", "aaa.bbb.fact:cuenta"])

Friendly regards,

Nick

Re: Freemarker sort_by

tfpadilla — Fri, 29 Aug 2008 11:57:03 GMT

Thanks again for your help.

I've checked everything and it seems to be ok and completely declared ( prefix and so on).

This is very curious:

If I try to use <#list space.children?sort_by(["properties","fact:cuenta"]) as child> in a STANDARD space it WORKS.

But I need some special properties also for the space that contains the documents, so I have a standard space with some aspects added.

These aspects are really simple and they are declared in the same custom model: fact model.

I include them in order to show their simplicity:

<aspect name="fact:factid">
         <title>contador espacio</title>
         <properties>
            <property name="fact:folderid">
               <type>d:int</type>
            </property>
         </properties>
      </aspect>
<aspect name="fact:factacum">
         <title>acumulado</title>
         <properties>
           <property name="fact:acumulado">
               <type>d:float</type>
            </property>
         </properties>
      </aspect>

<aspect name="fact:aspclienteid">
         <title>cliente asociado</title>
         <properties>
            <property name="factaspclienteid">
               <type>d:text</type>
            </property>
         </properties>
      </aspect>
<aspect name="fact:aspdocpres">
         <title>documentos presentes</title>
         <properties>
            <property name="factaspdocpres">
               <type>d:int</type>
            </property>
         </properties>
      </aspect>

Once I have done it, the exactly same <#list space.children?sort_by(["properties","fact:cuenta"]) as child> DOESN'T WORK in the "aspected" space.

Any idea?,
Thanks again, Nick

Teresa