topic Web-Script search - sort the search by custom content fields in Alfresco Archive

Web-Script search - sort the search by custom content fields

wmay — Thu, 22 Sep 2011 13:39:21 GMT

Is it possible to use the Web-script search to perform a search and to get back the result sorted by custom content fields ? We only where able to run such a search and to sort the result by the "Standard fields" but not to sort by own defined custom content fields.e.g. With the Share search i can s

Re: Web-Script search - sort the search by custom content fields

openpj — Sun, 20 Nov 2011 14:03:01 GMT

Yes, but you should create your own custom WebScript that can use your custom fields to do what you want.
Using Freemarker you can set the specific custom field used to order results:


<#list companyhome.childrenByLuceneSearch["TEXT:alfresco* AND TEXT:tutorial*"]?sort_by([custom:yourCustomField]) as child>
…
…
</#list>
‍‍‍‍‍‍

Hope this helps.

Re: Web-Script search - sort the search by custom content fields

ivanatap — Tue, 18 Dec 2012 15:58:51 GMT

Hi,

I did my search like this:

 <#list companyhome.childrenByLuceneSearch["

                            +(@cm\\:modifier:\"${person.properties.userName}\"

                             OR 

                            @cm\\:creator:\"${person.properties.userName}\")
 
                  +PATH:\".//*\"
                  
                  "]?sort_by([cm:modified]) as child>
</#list>‍‍‍‍‍‍‍‍‍‍‍‍

But, this doesn't work. Actually, this part does not work: ?sort_by([cm:modified])
Could anyone tells me where I made a mistake?

Thanks

Re: Web-Script search - sort the search by custom content fields

openpj — Tue, 18 Dec 2012 16:10:45 GMT

Try to use the following:

sort_by(["cm:modified"])‍

Hope this helps.

Re: Web-Script search - sort the search by custom content fields

ivanatap — Wed, 19 Dec 2012 08:27:10 GMT

Hi OpenPj,

Thanks for the quick answer.
I tried what you suggest, but than I got this error:

Error during processing of the template '?sort_by(…) failed at sequence index 0: The "cm:modified" subvariable was not found.'. Please contact your system administrator.