Find Favorite Spaces in Confluence via CQL

Question

Hello,

I want to use a CQL Query to find all favorite spaces for the currentUser in Confluence. Do someone has an idea how to do that?

To find all favorite pages it is easy

favourite = currentUser()

But I need this for Spaces.

We are using Confluence 6.12.2 and have Scriptrunner for Confluence installed (5.4.36).

Thanks

Katrin

Shannon S · Accepted Answer

Hi Katrin,

What are you going to be using this for? I believe you could do this with a SQL query instead.

You would want to combine How to list the users favourite pages and spaces but restrict it to a specific user using the method from How to list which spaces a user can access. For example,

WHERE um.lower_username = '<user_name>'

I'm not a wizard with SQL but I believe this could get the information you need.

Regards,

Shannon

Admin User_vu4cja · Accepted Answer

Hi Shannon,

Thanks for your answer. I need this for the navigation bar with the subspace plugin. There I want an entry for personal spaces.

I've found an other easy way to show all favorite spaces for the logged in user:

space.type = favorite and type = space

This works perfect.

Cheers

Katrin