Is it possible to list all pages with a given status?

[John Noonan]

Our team likes this little button, but can't find a way to query to find all the pages in a given status.

[Andy Gladstone · Accepted solution]

@John Noonan Welcome to the Atlassian Community. The status 'lozenge' is currently a static object on the pages that you use it on, and is not queryable or subject to any automations. It is a brand new feature in Confluence Cloud - and there has been a lot of community feedback about making this object part of the page content that can be queried and reported on. Stay tuned for future updates on the Status Icon - but for now it can only be viewed on a pag by page basis.

Hope this helps!

[Andy Gladstone]

@John Noonan please let me know if my answer assisted you. If it did, please click on the Accept Answer button so others looking for similar assistance can find it in the future.

[Jodi Neufeld]

+1 on being able to create reports based on page status!

[matilde.dueholm]

I just had a similar question, and someone lead me to this answer.

I think for me/us it would be nice just to be able to see the status in the page overview. As we could then use it to get an overview of what needs to be review etc, to have a mini contant review/approval flow

[Tauscher_H-D]

+1 for searching by page status

[Max Foerster - K15t]

Hi @John Noonan Welcome to the community! 👋🏼

Currently, you have no easy way to query pages based on their page status. Neither the Page Property Report macro nor the Confluence advanced search support page statuses. So the feature is great, but it's still missing essential features, like being able to easily edit the status as well. But they will hopefully follow over time.

If you are looking for this kind of reporting on pages and easily maintaining your content, I'd like to suggest having a look at our app Orderly Databases for Confluence on the Atlassian Marketplace.

The gif below shows you a snippet of a table in Orderly with linked pages and their page status (and some other metadata you usually add to pages), which you can not only view but also edit directly. Additionally, you can sort and filter based on that data, including page statuses. 😄

It's like tables and page properties but more powerful and smarter. 😄 We recently added support for the page status field to the app to work with it more easily internally and to have a workaround for the given limitations. 😕

You can edit the page status inline on the page itself without opening the editor in the Orderly macro. It's very similar to the page property table, with more features.

I realize this may not be the answer you were hoping for, but currently, even as a Confluence nerd, I don't know of a better way. 😅 If you have any further questions, let me know, and I will be happy to assist you.

Best, Max

[Bill Bailey]

Yes it is possible! You need to use the page-properties-macro on each page, and have one value as your status. Then you can have a report using the page-properties-report-macro to pull the information. I have used this structure many times as a way to store page attributes that can be easily queried.