I want to see everyone’s bookmarks. So I try this simple query in Data Explorer.
SELECT * from bookmarks
That returns no results. I added a bookmark of my own and ran it again. Still no results. Where are bookmarks stored, if not in the bookmarks table?
SELECT COUNT(id) FROM bookmarks
Sorry, I’m at a loss for what the problem might be. That makes no sense to me at all. I would think you would get some kind of error message or at least the 1 you know exists.
bookmarks table doesn’t seem to be getting used yet. It is part of some improvements that are being made to Discourse’s bookmarking functionality.
Currenty, you can get information about bookmarks with a query like this:
t.id AS topic_id,
COUNT(*) AS bookmark_count
FROM post_actions pa
JOIN posts p
ON p.id = pa.post_id
JOIN topics t
ON t.id = p.topic_id
WHERE pa.post_action_type_id = 1
AND t.deleted_at IS NULL
AND p.deleted_at IS NULL
GROUP BY t.id, t.user_id
ORDER BY bookmark_count DESC
Bookmarks can now be found in the