This article explains how to find a Confluence user favorites list by using SQL for Confluence app.
Instructions
The following query provides data for the users with the list of their respective favorite pages:
SELECT u.username, c.title FROM label l, content_label t, content c, user_mapping u WHERE l.labelid=t.labelid AND t.contentid=c.contentid AND t.owner = u.user_key;
- The output of the above query is as shown below:
This example is from the PostgreSQL database.