This article explains how how to find a confluence user the favorites list by of all Confluence users using the 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.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:
Code Block theme Midnight 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 a list of all users along with their respective favorite pages. The output of the above query is as
...
follows:
...
| Info |
|---|
| This example is for the Postgress databaseThe 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. |