Where clause - API

cancel
Showing results for 
Search instead for 
Did you mean: 
renatoc1
Active Member

Where clause - API

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

3 Replies
renatoc1
Active Member

Re: Where clause - API

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.

renatoc1
Active Member

Re: Where clause - API

Up

renatoc1
Active Member

Re: Where clause - API

Up