- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2018 07:23 AM
Hello,
I'm trying to use the REST API to retrieve audit data from Alfresco. In particular I want to return audit entries created after a specific date. The api-explorer gives some examples of returning audit data between dates using:
where=(createdAt BETWEEN ('first date', 'second date'))
This works, but what are the other operators?
I've tried AFTER, BEFORE, GREATERTHAN, > etc, but nothing seems to work.
Does anyone know if there are any other operators and where they are documented?
Many thanks
Paul
- Labels:
-
Alfresco Content Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2018 12:54 PM
To answer my own question...
I managed to track down the source code for the Audit API in GitHub. It seems that the only supported operators are =, AND and BETWEEN.
I've changed my code to use BETWEEN('start date', 'now') to return me all audit entries created after 'start date'
Regards
Paul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2018 12:54 PM
To answer my own question...
I managed to track down the source code for the Audit API in GitHub. It seems that the only supported operators are =, AND and BETWEEN.
I've changed my code to use BETWEEN('start date', 'now') to return me all audit entries created after 'start date'
Regards
Paul

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2020 03:01 AM
Will you please give step by step process of how to do site audit.
Thanks in Advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2020 06:09 AM
Hi @pedwards99
Well done on finding a solution - & thanks for updating us, really helpful to other users.
Cheers,
Problem solved? Click Accept as Solution!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2019 07:26 AM
Hi
I ran the REST API in the following way and succeeded.
where=(createdAt BETWEEN('2019-01-28T00:00:00.000Z','2019-01-29T14:59:59.000Z'))
Perhaps it is necessary to put it completely including time.
