cancel
Showing results for 
Search instead for 
Did you mean: 

Filter CMIS query from properties values

franciscoduarte
Champ in-the-making
Champ in-the-making

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,

1 REPLY 1

franciscoduarte
Champ in-the-making
Champ in-the-making

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,