This article explains how to find a confluence user favorites list by using SQL for Confluence app.
Instructions
The following query provides data of the user list, with the list of pages that are favorites to the confluence users.
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 for the Postgress database.