How can I list and count ALL bookmarks in the system?
I have been asked to analyze bookmarks, to determine such things as How many users make use of the bookmark feature in Khoros? What is the maximum number of bookmarks for a user? What is the...
If we use 'select count(*) from bookmarks,' it will only give the bookmarks at the current logged-in user level.
If we want all users bookmarks, we can use 'select * from bookmarks where subscriber.id = '${user.id}'.
1. Create an endpoint.
2. Get all users using the users API with cursor (recommended) or offset.
3. Then pass each user ID in the bookmarks query.
4. This endpoint will provide all the data in one place.
