Table: confluence_content
Content in a Confluence instance.
Examples
Get basic info about the content
select id, title, space_key, status, typefrom confluence_content;
Get the count of content type
select "type", count(*)from confluence_contentgroup by "type";
Get content with draft
in the title
select *from confluence_contentwhere title ilike '%draft%';
Schema for confluence_content
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
id | text | = | Automatically assigned when the content is created |
space_key | text | The space containing the content | |
status | text | The content status | |
title | text | The content title | |
type | text | The content type (page, blogpost, attachment or content) | |
version_number | bigint | The content version |