Table: confluence_content_label
Content labels in a Confluence instance.
Examples
Get basic info about the labels
select id, content_id, title, space_key, prefix, name, labelfrom confluence_content_label;
Get the count of content by label
select label, count(*)from confluence_content_labelgroup by label;
Get labels with documentation
in the name
select *from confluence_content_labelwhere name ilike '%documentation%';
Schema for confluence_content_label
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
content_id | text | Automatically assigned when the content is created | |
id | text | Automatically assigned when the label is created | |
label | text | The label | |
name | text | The label name | |
prefix | text | The label prefix | |
space_key | text | The space containing the content | |
title | text | The content title |