Whiteboards
Retrieves details about collaborative whiteboards created within Confluence, including titles, owners, and associated spaces.
Columns
| Name | Type | References | SupportedOperators | Description |
| Id [KEY] | String | =,!=,IN,NOT_IN | The unique identifier of the whiteboard within Confluence. | |
| Title | String | =,!=,IN,NOT_IN,LIKE | The title of the whiteboard as displayed in Confluence. | |
| Status | String | Indicates the current status of the whiteboard, such as active, draft, or archived. | ||
| SpaceKey | String |
Spaces.Key | =,!=,IN,NOT_IN | The unique key of the space that contains the whiteboard. |
| SpaceType | String |
Spaces.Type | =,!=,IN,NOT_IN | Specifies the type of space the whiteboard belongs to, such as global, personal, or team space. |
| Position | String | Defines the whiteboard's position or order within its parent space or container. | ||
| URL | String | The full URL used to access the whiteboard through the Confluence interface or API. | ||
| Excerpt | String | A short summary or snippet of the whiteboard content, typically used for previews or search results. | ||
| IsLatest | Boolean | If the value is 'true', this record represents the most recent version of the whiteboard. If the value is 'false', it refers to a previous version. | ||
| CreatedByUserName | String | =,!=,IN,NOT_IN | The username of the user who originally created the whiteboard. | |
| CreatedByUserType | String | Specifies the type of user who created the whiteboard, such as internal, external, or system account. | ||
| CreatedDate | Datetime | =,>,>=,<,<= | The date and time when the whiteboard was created. | |
| LastUpdatedDatetime | Datetime | =,>,>=,<,<= | The date and time when the whiteboard was last modified. | |
| LastUpdatedMessage | String | The revision message or note entered when the whiteboard was last updated. | ||
| LastUpdatedNumber | Integer | The version number associated with the most recent update of the whiteboard. | ||
| LastUpdatedUserName | String | The username of the user who performed the most recent update. | ||
| LastUpdatedUserType | String | Indicates the type of user who made the latest update, such as internal user or automated process. | ||
| LastUpdatedIsMinorEdit | Boolean | If the value is 'true', the latest change was a minor edit. If the value is 'false', it represents a major update. | ||
| LastUpdatedIsHidden | Boolean | If the value is 'true', the most recent version of the whiteboard is hidden from general visibility. If the value is 'false', it is visible. | ||
| PreviousVersionUserName | String | The username of the user who modified the previous version of the whiteboard. | ||
| PreviousVersionUserType | String | Specifies the type of user who updated the previous version, such as internal user or system account. | ||
| PreviousVersionDatetime | Datetime | The date and time when the previous version of the whiteboard was edited. | ||
| PreviousVersionMessage | String | The revision message or comment provided for the previous version. | ||
| PreviousVersionNumber | String | The version number assigned to the previous revision of the whiteboard. | ||
| PreviousVersionIsMinorEdit | Boolean | If the value is 'true', the previous version was a minor edit. If the value is 'false', it represented a major change. | ||
| PreviousVersionIsHidden | Boolean | If the value is 'true', the previous version of the whiteboard is hidden from users. If the value is 'false', it is visible. | ||
| LinksEditui | String | The URL of the edit interface (EditUI) for the whiteboard, allowing direct editing in Confluence. | ||
| LinksSelf | String | The self-referential API endpoint (Self link) for the whiteboard, used for retrieving its data programmatically. | ||
| LinksTinyui | String | The short link (TinyUI) version of the whiteboard's URL, providing a compact format for sharing. | ||
| LinksWebui | String | The standard web interface URL (WebUI) of the whiteboard as viewed in Confluence. | ||
| ItemURL | String | The complete URL reference to the whiteboard as displayed in the user interface. | ||
| ContainerId | String | The unique identifier of the container, such as the page or space, that holds the whiteboard. | ||
| AnonymousExportViewBody | String | Contains the whiteboard body in anonymous export view format, allowing public export without authentication. | ||
| AtlasDocFormatBody | String | Contains the whiteboard body in Atlas Document Format (ADF), supporting structured and rich content. | ||
| BodyViewBody | String | Contains the rendered view representation of the whiteboard content as displayed in Confluence. | ||
| DynamicBody | String | Contains the dynamic representation of the whiteboard body, used for interactive or real-time updates. | ||
| ExportViewBody | String | Contains the whiteboard body in export view format, suitable for use in external exports. | ||
| EditorBody | String | Contains the whiteboard body in the editor format used in the Confluence editor. | ||
| Editor2Body | String | Contains the whiteboard body in the Editor2 format, used by newer Confluence editor versions. | ||
| StorageBody | String | Contains the whiteboard content in Confluence Storage Format, preserving text, drawings, and formatting. | ||
| StyledViewBody | String | Contains the whiteboard body in styled view format, showing the rendered version with formatting and layout. |
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 whiteboards. |