AnsweredAssumed Answered

Sort fts-alfreco query results by custom field

Question asked by superdh on Jun 4, 2019
Latest reply on Jun 6, 2019 by 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 ?

Outcomes