topic Re: Where clause - API in Alfresco Forum

Where clause - API

renatoc1 — Wed, 27 Jul 2022 11:29:07 GMT

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

Re: Where clause - API

renatoc1 — Wed, 27 Jul 2022 13:57:26 GMT

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.

Re: Where clause - API

renatoc1 — Tue, 16 Aug 2022 13:58:56 GMT

Re: Where clause - API

renatoc1 — Wed, 05 Oct 2022 20:14:01 GMT

Re: Where clause - API

renatoc1 — Thu, 15 Dec 2022 16:42:50 GMT