nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Get a list of pages for all spaces?

Darryl St. Pierre

I'm working on a project to consolidate some of our spaces, and need to address duplicate page names such as "How-to articles" (each former Space will have it's own page, but duplicate pages can't exist).

I'd like to be able to pull a list of all spaces and pages under each, so that we can then rename the duplicates so they don't conflict when consolidating.

Is there a way to accomplish this?

Accepted answers

Jonathan Smith

Would the children display macro be sufficient?

Target page would be your space home page.
Change descendants to a large number.

All comments

Jonathan Smith

Would the children display macro be sufficient?

Target page would be your space home page.
Change descendants to a large number.

Darryl St. Pierre

Thanks for the response. This would be good except that we have about 400 spaces to review.

Jonathan Smith

SQL my friend:

Make a join between dbo.SPACES and dbo.CONTENT:

select DISTINCT b.SPACENAME, a.TITLE
from dbo.CONTENT a left join dbo.SPACES b on a.SPACEID=b.SPACEID
where a.CONTENTTYPE='PAGE'
and a.TITLE is not NULL
and b.SPACENAME is not NULL
order by b.SPACENAME

Export to Excel when finished. Best of luck!

Darryl St. Pierre

Thanks Jonathan! I'll run this by my SQL admin. Seems pretty straightforward.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server