Page Comparison

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

...

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 below:

   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;

   
   

2. The output of the above query is as shown below:
   Image Modified
   

...