How do I find all pages by owner?

Joshua Bentley
Contributor
July 3, 2024

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?

4 answers

2 accepted

2 votes
Answer accepted
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 4, 2024

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. 

Joshua Bentley
Contributor
July 8, 2024

Thanks, Aron. So if I understand correctly, in order to use that CQL search, I need that third party app?

Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 9, 2024

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.)

Like Joshua Bentley likes this
1 vote
Answer accepted
Kristian Klima
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 3, 2024

Hi @Joshua Bentley 

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.

Joshua Bentley
Contributor
July 8, 2024

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.

1 vote
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 3, 2024

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.

searchbar.pngadvance_search.pngedited_created.png

The above includes creators and editors, to limit it to just creators

creator.png

 

Joshua Bentley
Contributor
July 8, 2024

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.

Like Rune C Foyn likes this
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 8, 2024

According to this https://jira.atlassian.com/browse/CONFCLOUD-77061 You should be able to search for owner now in cql.

Joshua Bentley
Contributor
July 9, 2024

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.

Joshua Bentley
Contributor
July 8, 2024

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.

Like Rune C Foyn likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events