Sort fts-alfreco query results by custom field

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

superdh

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 to order the results by field4 but nothing works :

"nodes" : [{
   "id":"111",
   "name" : "...",
   "search" : {
      "language" : "fts-alfresco",
      "query" : "=ns:field1:'value' and =ns:field2:'value' and =ns:field3:'value'"
   },

   "sort" : [
      {"column" : "ns:field4"}
   ]

}]

I used https://docs.alfresco.com/5.0/references/API-JS-query.html to find the code... But i don't know if I can order my files by using fts-alfresco language. How can I solve this please ?

afaust

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).