Filter CMIS query from properties values

franciscoduarte — Fri, 22 Oct 2021 16:32:32 GMT

Hi,

Is there a way to filter a query from the properties values?

I tried this way :

{
"query": {
"language": "cmis",
"query": "select * from cmis:document WHERE IN_FOLDER('71af2bec-22d4-11ec-9621-0242ac130002') AND properties.cm:title LIKE 'titleValue'"
},
"paging": {
"maxItems": 100,
"skipCount": 0
},
"include": ["properties"]
}

But I get the following error :

{ "error": { "errorKey": "framework.exception.ApiDefault", "statusCode": 500, "briefSummary": "No selector for properties", "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": "46f5ef58-6674-4ada-aa9f-b4fcd70de8bc" } }

Could the filterQueries be a solution?

Thank you,

Re: Filter CMIS query from properties values

franciscoduarte — Fri, 22 Oct 2021 16:54:15 GMT

I found this solution but its with language afts. I think this can work for me but anyways, I'm curious to know if there's something possible, simple and similar with though cmis.

{
"query": {
"query": "PATH:'/app:company_home/st:sites/cm:company-site/cm:documentLibrary/cm:FolderA/*'",
"language": "afts"
},
"filterQueries": [{"query": "cm:title:titleValue"}],
"include": ["properties"]
}

Best regards,

topic Re: Filter CMIS query from properties values in Alfresco Forum

Filter CMIS query from properties values

Re: Filter CMIS query from properties values