topic Re: Sort fts-alfreco query results by custom field in Alfresco Forum

Sort fts-alfreco query results by custom field

superdh — Tue, 04 Jun 2019 10:48:46 GMT

Hello,I use smart folders to query my files and everything works fine, with the following json code :"nodes" : [{ "id":"111", "name" : "...", "search" : { "language" : "fts-alfresco", "query" : "=ns:field1:'value' and =ns:field2:'value' and =ns:field3:'value'" }}]Now, I try t

Re: Sort fts-alfreco query results by custom field

afaust — Tue, 04 Jun 2019 14:40:04 GMT

Typically the sort column needs to be specified with an @ in front of the name. Also, make sure your custom field is indexed and uses either tokenisation mode "false" or "both" (unless you can guarantee your query will be executed by the DB).

Re: Sort fts-alfreco query results by custom field

superdh — Wed, 05 Jun 2019 07:32:50 GMT

Thanks for you answer but it is still not working.

My property is the following :

<property name="ns:title">
   <title>Title</title>
   <type>d:text</type>
   <mandatory>true</mandatory>
   <index enabled="true">
      <tokenised>false</tokenised>
      <facetable>false</facetable>
   </index>
</property>

I tried the following sorts : "@ns:title", "@{ns}title", "@{http://www.company.org/model/ns/content/1.0 }title"

What is the exact format expected ?

Re: Sort fts-alfreco query results by custom field

douglascrp — Wed, 05 Jun 2019 18:56:07 GMT

AFAIK, there is no "sort" property for the Smart Folder configuration file (Smart Folder Template syntax | Alfresco Documentation)

Besides that, I believe it would not make sense to have it, as the sort order will be defined by the Share's document library component.

Please, correct me if I am wrong.

Re: Sort fts-alfreco query results by custom field

afaust — Wed, 05 Jun 2019 20:28:22 GMT

Right - I did not think of that. See https://docs.alfresco.com/5.2/concepts/sf-ref-template-guidance.html for details about the syntax.

Re: Sort fts-alfreco query results by custom field

superdh — Thu, 06 Jun 2019 08:12:44 GMT

Thank you, I will stop to search for nothing !

The sort option for DocumentLibrary works well, I can see the sort option in the list

<config evaluator="string-compare" condition="DocumentLibrary">
   <sorting>
      <sort label="label">ns:field</sort>
   </sorting>
</config>