Filter CMIS query from properties values

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.

franciscoduarte

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,

franciscoduarte

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,