Page Comparison

This article explains how This article explains how to find a Confluence user's favorites list by using the SQL for Confluence app.

Instructions

1. 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 belowIn a Confluence page, search for the SQL Query macro or enter {sql and select the macro.

2. 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 information about all users with the list of their respective favorite pages. The output of the above query is as

...

follows:

...

Image Added