How to list the most used labels in Confluence
プラットフォームについて: 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 は除く
問題
As an administrator, I'd like to have the precise number of times each label has been added to a content.
ソリューション
The following query produces a list with the label name and the number of pages or attachments containing that label:
SELECT count(*) AS label_count,
l.name AS label_name
FROM label l
JOIN content_label c_l ON l.labelid = c_l.labelid
JOIN content c ON c.contentid = c_l.contentid
WHERE l.namespace = 'global'
GROUP BY label_name
ORDER BY label_count DESC;
最終更新日 2018 年 9 月 28 日
Powered by Confluence and Scroll Viewport.