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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.