Page Comparison

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

Instructions

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

   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 Added