Blogposts
Get information about a blogpost within a space.
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 '=,!=,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 | ReadOnly | References | SupportedOperators | Description |
| Id [KEY] | String | True | =,!=,IN,NOT_IN |
Id of the content. | |
| Type | String | True |
Type of the content. | ||
| Title | String | False | =,!=,IN,NOT_IN |
Title of the content. | |
| Status | String | False |
Status of the content. | ||
| SpaceKey | String | True |
Spaces.Key | =,!=,IN,NOT_IN |
The key of the space that the content belongs to. |
| SpaceType | String | True |
Spaces.Type | =,!=,IN,NOT_IN |
The type of the space that the content belongs to. |
| Position | String | True |
Position of the content. | ||
| URL | String | True |
URL of the content. | ||
| Excerpt | String | True |
Excerpt of the content. | ||
| IsLatest | Boolean | True |
Indicator if this is the latest version of the content. | ||
| CreatedByUserName | String | True | =,!=,IN,NOT_IN |
Username of the user who created the content. | |
| CreatedByUserType | String | True |
Type of the user who created the content. | ||
| CreatedDate | Datetime | False | =,>,>=,<,<= |
Datetime for the creation of the content. | |
| LastUpdatedDatetime | Datetime | True | =,>,>=,<,<= |
Datetime of the last updated version of the content. | |
| LastUpdatedMessage | String | True |
Message of the last updated version. | ||
| LastUpdatedNumber | Integer | True |
Number of the last updated version. | ||
| LastUpdatedUserName | String | True |
Username of the user who updated the latest version. | ||
| LastUpdatedUserType | String | True |
Type of the user who updated the latest version. | ||
| LastUpdatedIsMinorEdit | Boolean | True |
Indicator if this version is a minor edit. | ||
| LastUpdatedIsHidden | Boolean | True |
Indicator if the last updated version is hidden or not. | ||
| PreviousVersionUserName | String | True |
Username of the user who updated the previous version. | ||
| PreviousVersionUserType | String | True |
Type of the user who updated the previous version. | ||
| PreviousVersionDatetime | Datetime | True |
Datetime when the previous version was edited. | ||
| PreviousVersionMessage | String | True |
Message for the previously edited version. | ||
| PreviousVersionNumber | String | True |
Number of the previously edited version. | ||
| PreviousVersionIsMinorEdit | Boolean | True |
Indicator if the previous version was a minor edit. | ||
| PreviousVersionIsHidden | Boolean | True |
Indicator if the previous version was hidden or not. | ||
| LinksEditui | String | True |
The LinksEditui of the page content. | ||
| LinksSelf | String | True |
The LinksSelf of the content. | ||
| LinksTinyui | String | True |
The LinksTinyui of the content. | ||
| LinksWebui | String | True |
The LinksWebui of the content. | ||
| ItemURL | String | True |
The URL reference of the element in UI. | ||
| ContainerId | String | True |
The Id of the container of the content. | ||
| StorageBody | String | False |
The body content storage. | ||
| AtlasDocFormatBody | String | False |
The body content in atlas doc format. | ||
| SpaceId | String | False |
The body content in atlas doc format. | ||
| VersionNumber | String | False |
The body content in atlas doc format. | ||
| VersionMessage | String | False |
The body content in atlas doc format. |
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 |
CQL (Confluence Query Language) allows you to build structured queries. |