Find all empty pages and drafts in Confluence datacenter search

[Rathna]

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

[Septa Cahyadiputra]

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