This article explains how to find a Confluence user's favorites list using the SQL for Confluence app.
Instructions
- In a Confluence page, search for the SQL Query macro or enter {sql and select the macro.
Enter the following query in the macro and select Output format as Wiki:
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 query retrieves information about all users with the list of their respective favorite pages. The output of the above query is as follows:
The query used in this example was written for PostgreSQL database. You may need to modify the query depending on the database used in your organization.