How to find pages in Confluence with a certain number of labels
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
目的
This guide is to show Confluence administrators how to search for pages with labels associated with it. Note that the logic in the queries can be modified depending on the information you are trying to find.
ソリューション
- The easiest way to find this information is through the database.
Note that the following syntax was written for PostgreSQL ad tested with Confluence version 5.8.13, but the syntax should be similar for other database flavours
Page with more than 1 labelSELECT c.title as PageTitle, count(title) as NumberOfLabels from content_label cl inner join label l on cl.labelid = l.labelid inner join content c on c.contentid = cl.contentid where cl.labelabletype = 'CONTENT' group by c.title having COUNT(c.title) = 1;Page with more than 1 labelSELECT C.TITLE AS PAGETITLE, COUNT(TITLE) AS NUMBEROFLABELS FROM CONTENT_LABEL CL INNER JOIN LABEL L ON CL.LABELID = L.LABELID INNER JOIN CONTENT C ON C.CONTENTID = CL.CONTENTID WHERE CL.LABELABLETYPE = 'CONTENT' GROUP BY C.TITLE HAVING COUNT(C.TITLE) = 1;Attachments with more than 1 labelSELECT c.title as PageTitle, count(title) as NumberOfLabels from content_label cl inner join label l on cl.labelid = l.labelid inner join content c on c.contentid = cl.contentid where cl.labelabletype = 'ATTACHMENT' group by c.title having COUNT(c.title) = 1;Attachment with more than 1 labelSELECT C.TITLE AS PAGETITLE, COUNT(TITLE) AS NUMBEROFLABELS FROM CONTENT_LABEL CL INNER JOIN LABEL L ON CL.LABELID = L.LABELID INNER JOIN CONTENT C ON C.CONTENTID = CL.CONTENTID WHERE CL.LABELABLETYPE = 'ATTACHMENT' GROUP BY C.TITLE HAVING COUNT(C.TITLE) = 1;
最終更新日 2023 年 6 月 22 日
Powered by Confluence and Scroll Viewport.