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; } } }

Have all pages using a macro

Jacynthe_Thibault

Hi,

We will be migrating to Confluence Cloud soon, but first we need to have all pages using SQL macros because we don't want these macros in the cloud.

I saw in "Administration/general configuration/macro usage", I have a link to pages that use the macro in question. But I just noticed that if someone has restricted the permissions on a page it does not appear in these lists.

So I would like a way (maybe by SQL query) to have the list of all pages using a macro (it's a third party macro) regardless of whether there have been restrictions on it.

Thanks

Accepted answers

Kian Stack Mumo Systems

@Jacynthe_Thibault,

Please take a look at this page which contains details about the query you would need to run.

I would recommend using the source editor plugin to find out what the macro is called on the back end.

Thanks,

Kian

All comments

Stiltsoft support

Hi @Jacynthe_Thibault ,

Maybe this thread gives you some hints for the case https://community.atlassian.com/t5/Confluence-questions/Reporting-of-pages-using-Table-Excerpt-Include/qaq-p/1556626

Kian Stack Mumo Systems

@Jacynthe_Thibault,

Please take a look at this page which contains details about the query you would need to run.

I would recommend using the source editor plugin to find out what the macro is called on the back end.

Thanks,

Kian

Jacynthe_Thibault

Hi, I tried with the field search MacroName: sql but it gives only the page where I have permission to see it. It there are a restriction I don't see it (even if I am administrator in COnfluence)

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud