Table: confluence_content_version
Content versions in a Confluence instance.
Examples
Get basic info about the version
select *from confluence_content_version;
Get the count of content by label
select label, count(*)from confluence_content_versiongroup by label;
Get the 50 oldest pages
select title, space_key, "when"from confluence_content_version join confluence_content using (id)order by "when" asclimit 50;
Schema for confluence_content_version
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
accountId | text | The account ID for the content version's author. | |
displayName | text | The display name for the content version's author. | |
text | The email for the content version's author. | ||
id | text | = | The ID of the content. |
message | text | The content version message. | |
minor_edit | boolean | Whether the version corresponds to a minor edit. | |
number | bigint | The content version number. | |
userKey | text | The user key for the content version's author. | |
username | text | The username for the content version's author. | |
when | text | When the content version was published. |