Find all empty pages and drafts in Confluence datacenter search

Rathna December 4, 2024

Hi all,

Would it be possible to find all of the empty pages and drafts from the top right hand side search in confluence data center.

 

Thanks in advance

1 answer

1 vote
Septa Cahyadiputra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 4, 2024

Hi @Rathna

Welcome to the community. In regards to your question, I don't believe it is possible for you to search empty pages and draft that way. However, since you are using data center you might be able to use the query below to start:


SELECT c.CONTENTID, c.CONTENTTYPE, c.TITLE, s.SPACEKEY
FROM CONTENT c
JOIN BODYCONTENT bc
    ON c.CONTENTID = bc.CONTENTID
JOIN SPACES s
    ON c.SPACEID = s.SPACEID
WHERE c.PREVVER IS NULL
    AND c.CONTENTTYPE IN ('PAGE', 'BLOGPOST', 'DRAFT')
    AND bc.BODY LIKE '%<INSERT_KEYWORD_HERE>%';

 Tricky part is the condition of the BODY. You might be able to use regex to achieve what you need.

Hope it helps.

Regards,
Septa Cahyadiputra

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.5.14
TAGS
AUG Leaders

Atlassian Community Events