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
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
Katrin,
Happy to hear you were able to resolve the issue in the add-on!
Thank you for letting us know how you did it.
Take care, and have a nice week.
Regards,
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.