Confluence DB SQL check the number of pages that are affected

[Jurica Petricevic]

Hi Community,

we want to check exactly how many pages on our instance are affected by this problem:

Include Page Macro will not render pages with colon (:) in the title

[CONFSERVER-55920] Include Page Macro will not render pages with colon (:) in the title - Create and track feature requests for Atlassian products.

Can somone help us with the DB SQL query?

Best Regards

Jurica Petricevic

[Thomas Deiler]

Dear @Jurica Petricevic ,

two options:

• write recursive REST script, that checks the page title of all pages
• find (this is the tricky part) the right DB table, where the title is stored and output all page ids

Unfortunately the tables are not public documented.

So long

Thomas

[Jurica Petricevic]

Nobody cared about something like this before?

I thought the Community already had a solution for it.

Thx @Thomas Deiler for ur answer.

Best regards

Jurica Petricevic

[Thomas Deiler]

Dear @Jurica Petricevic ,

for sure there is somebody in the community, who had a similar problem. The question is, is that person reading this question at the right moment?

So long

Thomas