Find all empty pages and drafts in Confluence datacenter search

Rathna_0u8woc

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_zgeimr

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:

---

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

 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