Where are favorite pages stored in the database?

[ITops123]

I'm trying to run a sql query on what pages people have favorited.

Where does this information live in the Confluence database?

[Mallmann]

Hey,

Just to update this topic in case anyone have the same question, I created a query for this:

SELECT s.spacename, um.username
FROM spaces s INNER JOIN content_label cl ON s.spacedescid = cl.contentid
INNER JOIN user_mapping um ON cl.owner = um.user_key
INNER JOIN label l ON cl.labelid = l.labelid AND l.name = 'favourite';

Hope it helps :)

Best regards,

Eduardo Mallmann

Atlassian Support

[ITops123]

I figured out the answer for myself.

Favorite pages are treated as labels. You can apply the "favourite" label (not the spelling) to a page. So you can see what pages have been favorited by looking up the favourite labelid in the label table, then joining it to the content_label table to figure out what content has the labelid applied to it.

In order to get a table showing you the title of the page and who favorited it, you'd have to join the content table to the join above.

[Arya Banerjee]

Also, is there a way to get information on favorites from Confluence Home directory?

Regards,

Arya

[Arya Banerjee]

Hi,

The above query fetches the spaces. Could you please help me in pointing out the pages along with the spaces marked as favorite from database?

Regards,

Arya