Blogposts
Retrieves detailed information about blog posts, including titles, authors, publication dates, and associated spaces.
Table Specific Information
Select
The add-in will use the Confluence API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in. You can also search for Attachments using CQL (Confluence Query Language).
- Id supports the '=,!=,IN,NOT IN' comparisons.
- Type supports the '=,!=,IN,NOT IN' comparisons.
- Title supports the '=,!=,LIKE,NOT LIKE,IN,NOT IN' comparisons.
- SpaceKey supports the '=,!=,IN,NOT IN' comparisons.
- SpaceType supports the '=,!=,IN,NOT IN' comparisons.
- CreatedByUserName supports the '=,!=,IN,NOT IN' comparisons.
- CreatedDate supports the '=,!=,>,>=,<,<=' comparisons.
- LastUpdatedDatetime supports the '=,!=,>,>=,<,<=' comparisons.
For example, the following queries are processed server side:
SQL
SELECT * FROM Blogposts WHERE Id = '1234'
SELECT * FROM Blogposts WHERE Id IN ('1234', '2345')
SELECT * FROM Blogposts WHERE Id = '123458' AND Type = 'blogpost'
SELECT * FROM Blogposts WHERE CreatedDate <= '2019/03/29 15:00' AND Id IN ('1234', '2345')
Additionally Id, Type, Title, CreatedDate, CreatedByUserName, AND LastUpdatedDatetime columns can be used in the ORDER BY clause, as following:
SELECT * FROM Blogposts ORDER BY Id DESC SELECT * FROM Blogposts ORDER BY CreatedByUserName ASC
CQL
Note: Filtering with CQL has the highest priority and all the other filters except "Excerpt" will be ignored when CQL filter is present in the query.
SELECT * FROM Blogposts WHERE CQL = 'creator = currentUser() AND content = "1234" OR space.type = "global"'
Columns
| Name | Type | References | SupportedOperators | Description |
| Id [KEY] | String | =,!=,IN,NOT_IN | Unique identifier of the blog post within Confluence. Used to reference the post in related operations or queries. | |
| Type | String | =,!=,IN,NOT_IN | Specifies the content type, indicating that this record represents a blog post. | |
| Title | String | =,!=,IN,NOT_IN,LIKE | The title of the blog post as displayed in Confluence, used for identification and navigation. | |
| Status | String | Indicates the current publishing state of the blog post, such as current, draft, or archived. | ||
| SpaceKey | String |
Spaces.Key | =,!=,IN,NOT_IN | The unique key of the space in which the blog post is published. This links the content to its workspace. |
| SpaceType | String |
Spaces.Type | =,!=,IN,NOT_IN | Specifies the type of space that contains the blog post, such as global, team, or personal. |
| Position | String | Defines the placement or ordering of the blog post within the space or among other content items. | ||
| URL | String | The full URL that provides direct access to the blog post through the Confluence interface or API. | ||
| Excerpt | String | A short summary or preview of the blog post content, typically displayed in listings or search results. | ||
| IsLatest | Boolean | If the value is 'true', this record represents the latest published version of the blog post. If the value is 'false', it refers to a previous version. | ||
| CreatedByUserName | String | =,!=,IN,NOT_IN | The username of the user who originally created and published the blog post. | |
| CreatedByUserType | String | Specifies the type of user who created the blog post, such as internal user, external collaborator, or system account. | ||
| CreatedDate | Datetime | =,>,>=,<,<= | The date and time when the blog post was initially created and saved in Confluence. | |
| LastUpdatedDatetime | Datetime | =,>,>=,<,<= | The date and time when the blog post was last edited or updated. | |
| LastUpdatedMessage | String | The revision message or comment entered by the author when saving the most recent version. | ||
| LastUpdatedNumber | Integer | The version number associated with the latest update of the blog post. | ||
| LastUpdatedUserName | String | The username of the user who made the most recent update to the blog post. | ||
| LastUpdatedUserType | String | Indicates the type of user responsible for the latest update, such as internal, external, or system. | ||
| LastUpdatedIsMinorEdit | Boolean | If the value is 'true', the latest change was a minor edit that did not significantly alter the content. If the value is 'false', the edit was a major revision. | ||
| LastUpdatedIsHidden | Boolean | If the value is 'true', the latest version of the blog post is hidden from general visibility. If the value is 'false', it is publicly visible. | ||
| PreviousVersionUserName | String | The username of the user who created or modified the previous version of the blog post. | ||
| PreviousVersionUserType | String | Specifies the type of user who edited the previous version, such as internal user or automated process. | ||
| PreviousVersionDatetime | Datetime | The date and time when the previous version of the blog post was last modified. | ||
| PreviousVersionMessage | String | The revision message or note associated with the previous version of the blog post. | ||
| PreviousVersionNumber | String | The version number assigned to the previous revision of the blog post. | ||
| PreviousVersionIsMinorEdit | Boolean | If the value is 'true', the previous version was marked as a minor edit. If the value is 'false', it was a major revision. | ||
| PreviousVersionIsHidden | Boolean | If the value is 'true', the previous version of the blog post is hidden from visibility. If the value is 'false', it is viewable by users. | ||
| LinksEditui | String | The URL of the edit interface (EditUI) for the blog post, allowing direct modification from the Confluence editor. | ||
| LinksSelf | String | The self-referential API endpoint (Self link) for the blog post, used to retrieve its details programmatically. | ||
| LinksTinyui | String | The short link (TinyUI) version of the blog post URL, providing a concise format for sharing. | ||
| LinksWebui | String | The standard web interface URL (WebUI) of the blog post as viewed within the Confluence site. | ||
| ItemURL | String | The complete URL reference to the blog post as displayed in the user interface. | ||
| ContainerId | String | The identifier of the container, typically the space or content collection, that holds the blog post. | ||
| StorageBody | String | The full content of the blog post in Confluence Storage Format, which preserves rich text, macros, and formatting. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| CQL | String | Represents a Confluence Query Language (CQL) expression used to build structured queries for retrieving or filtering blog posts. |