Page Comparison

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

...

1. The following query provides data of for the user list, users with the list of pages that are favorites to the confluence users.their respective favorite pages:

   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