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. Write the below code in a SQL Query macro and select Output format as Wiki as shown below:
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.