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:

   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 RemovedImage Added
   

...