user favourite space in confluence

[SherryX]

I tried to migrate confluence database from Postgres to Oracle, use .XML export/import, but after imported, my favourite spaces became a lot more than before, just wonder how this happened and where is the favourate space flag in the database (I'd like to check in the database)?

thanks

[Jeff Thomas · Accepted solution]

Hi Sherry,

I dug around in the database and it looks like favourites are stored as labels in Confluence. The query below should return a list of favourites for the username provided. You may need to make some modifications depending on your setup.

select spaces.spacename, spaces.spaceid, user_mapping.username, content_label.labelid, user_mapping.user_key
from USER_MAPPING, LABEL, content_label, content, spaces
where USERNAME = 'admin'
and LABEL.NAME = 'favourite'
and content.contenttype = 'SPACEDESCRIPTION'
and LABEL.OWNER = user_mapping.USER_KEY
and content_label.labelid = label.labelid
and content.contentid = content_label.contentid
and spaces.spaceid = content.spaceid;

[SherryX]

Thanks a lot for your help, Jeff.