I'm looking to pull a list of all pages owned by specific people on my team. I've seen a lot of pages with suggestions for using Advanced Search, but none of them work. I also saw an update here: https://jira.atlassian.com/browse/CONFCLOUD-77061 which indicates that it's possible, but it's unclear how to use the query and putting it into the search field does not yield the results I need.
I also see that there's an addon that we could subscribe to, but that seems silly. Surely there's a way to do this natively.
Can anyone explain to me how to do this as if I were a grandparent with some experience with Confluence Cloud, but by no means a pro?
You can search for the pages owned by a specific user in CQL, for example:
owner = currentUser()
The problem is that CQL is not directly available on the Confluence Cloud UI, don't ask me why. But the CQL Search third party app makes it easy to run CQL searches.
Thanks, Aron. So if I understand correctly, in order to use that CQL search, I need that third party app?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes.
If you want to run CQL searches conveniently from the UI, then you need that app. (It is very likely that you want to.)
If it is sufficient to run CQL searches by manipulating the URL in your browsers address bar and seeing the results as a JSON document, then you don't need that app. (It is unlikely that you want this, but this is part of a precise answer.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try some space admin app from the marketplace or Confluence Databases.
Once you get all the pages from a space into a DB, you can use filtering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks, Kristian! And thanks for your page. It doesn't look like our admin turned on Databases for us yet. I just requested it since that seems like it would help immensely.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I believe this is answered in https://community.atlassian.com/t5/Confluence-questions/How-to-find-list-of-pages-created-by-specific-user-in-confluence/qaq-p/1247759
However, let me paint some screenshots.
The above includes creators and editors, to limit it to just creators
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Shawn! I read that article and the instructions before I posted. Sadly, it doesn't work to show me who the current owner is. The current owner is not always the contributor or the creator.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
According to this https://jira.atlassian.com/browse/CONFCLOUD-77061 You should be able to search for owner now in cql.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I saw that one too. Sadly, that doesn't seem to be accurate. At least not for our instance. I'll check with our admin to see if maybe they missed any updates or necessary settings changes on our end.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Joshua Bentley Welcome, you might check this: link: https://community.atlassian.com/t5/Confluence-questions/How-to-find-list-of-pages-created-by-specific-user-in-confluence/qaq-p/1247759
HTH
Nicolas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Nicolas! I did check out that article and the instructions before I posted.
Unfortunately, it doesn't work to show me who the current owner is. The current owner is not always the contributor or the creator.
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.