Where clause - API

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.

renatoc1

Where can i find all the "Where clauses" for consume The Alfresco APIs?

Example:

http://localhost:8080/alfresco/api/-default-/public/alfresco/versions/1/audit-applications/alfresco-access/audit-entries?where=(createdAt%20BETWEEN%20('2019-12-20T09%3A00%3A00.000%2B0000'%2C'2019-12-20T10%3A00%3A00.000%2B0000'))"

"BETWEEN" is one of them

renatoc1

I want to filter the id 1 from

{
    "list": {
        "pagination": {
            "count": 100,
            "hasMoreItems": true,
            "totalItems": 253,
            "skipCount": 0,
            "maxItems": 100
        },
        "entries": [
            {
                "entry": {
                    "id": "1",
                    "auditApplicationId": "alfresco-access",
                    "createdByUser": {
                        "id": "admin",
                        "displayName": "Administrator"
                    },
                    "createdAt": "2022-07-26T03:42:39.662+00:00",
                    "values": null
                }
            },
            {
                "entry": {
                    "id": "2",
                    "auditApplicationId": "alfresco-access",
                    "createdByUser": {
                        "id": "admin",
                        "displayName": "Administrator"
                    },
                    "createdAt": "2022-07-26T03:42:41.053+00:00",
                    "values": null
                }
            }
        ]
    }
}

and

localhost:8081/api/v1/audit-applications/alfresco-access/audit-entries?where=(id = 1)

doesn't work.