Sorting custom properties with search api and PATH

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.

pdovhomilja

AHello,

i'm trying sorting everything by cutoom properties, but when i will use PATH in query, than server return 500. For example, i would like to get results for my custom type "ssl:document" and my property "sslid". If i will use query as bellow i will get response with 500

{
  "error": {
    "errorKey": "framework.exception.ApiDefault",
    "statusCode": 500,
    "briefSummary": "03021026 Request failed 500 /solr/alfresco/afts?wt=json&fl=DBID%2Cscore&rows=5&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DICTIONARY&sort=cm%3Aauthor+desc&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON&fq=%7B%21afts%7D%28-ASPECT%3A%22clf%3Aclassified%22+OR+%28sc%3Aclassification%3A%22TS%22+OR+sc%3Aclassification%3A%22S%22+OR+sc%3Aclassification%3A%22C%22+OR+sc%3Aclassification%3A%22U%22+%29%29",
    "stackTrace": "For security reasons the stack trace is no longer displayed, but the property is kept for previous versions",
    "descriptionURL": "https://api-explorer.alfresco.com",
    "logId": "cd5118d0-f13c-455c-98de-4b9de0beb4d0"
  }
}

this doesn't work:

{
   "paging":{
      "maxItems":5,
      "skipCount":0
   },
   "query":{
      "language":"afts",
      "query":"PATH:'/app:company_home/st:sites/cm:Mailroom/cm:documentLibrary/cm:Unfinished//*' AND TYPE:'ssl:document'"
   },
   "sort":{
      "ascending":false,
      "field":"ssl:pid",
      "type":"FIELD"
   }
}

also this doesn't work

{
   "paging":{
      "maxItems":5,
      "skipCount":0
   },
   "query":{
      "language":"afts",
      "query":"PATH:'/app:company_home/st:sites/cm:Mailroom/cm:documentLibrary/cm:Unfinished//*'"
   },
   "sort":{
      "ascending":false,
      "field":"cm:author",
      "type":"FIELD"
   }
}

but this works:

{
   "paging":{
      "maxItems":5,
      "skipCount":0
   },
   "query":{
      "language":"afts",
      "query":"TYPE:'ssl:document'"
   },
   "sort":{
      "ascending":false,
      "field":"ssl:pid",
      "type":"FIELD"
   }
}

Any idea how to sort by my properties and keep PATH in the query?

Thank you

 

angelborroy

Can you see any other stack trace in the log?