PageComments
Retrieves all comments made on a particular page, including text content, authors, and creation dates.
Table Specific Information
Select
The connector will use the Confluence API to process WHERE clause conditions built with the following column and operator.
Note: PageId is required in order to query the PageComments view.
- PageId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PageComments WHERE PageId = '163902'
SELECT * FROM PageComments WHERE PageId IN ('163902', '33106')
Columns
| Name | Type | References | SupportedOperators | Description |
| Id [KEY] | String | The unique identifier of the comment associated with the specified page. | ||
| ExpandableAncestors | String | Provides a link to ancestor elements in the hierarchy, such as the parent page or higher-level comments. | ||
| ExpandableChildren | String | Links to any nested replies or child comments related to the current comment. | ||
| ExpandableContainer | String | Provides a reference to the container element, typically the page that holds this comment. | ||
| ExpandableDescendants | String | Links to all descendant comments that can be expanded under this comment, displaying the full discussion thread. | ||
| ExpandableHistory | String | Links to the revision history of the comment, showing previous edits and versions. | ||
| ExpandableMetadata | String | Links to the expandable metadata for the comment, such as labels, properties, or custom fields. | ||
| ExpandableOperations | String | Lists the operations that can be performed on the comment, such as edit, delete, or reply. | ||
| ExpandableRestrictions | String | Links to the access restrictions applied to the comment, specifying who can view or edit it. | ||
| ExpandableSpace | String | Provides a link to the space in which the comment's parent page is located. | ||
| ExpandableVersion | String | Links to version information for the comment, including details about the latest edit and author. | ||
| LinksSelf | String | The self-referential API endpoint (Self link) for the comment, used to retrieve its data programmatically. | ||
| LinksWebui | String | The standard web interface URL (WebUI) for the comment as viewed in the Confluence page. | ||
| BodyExpandableAnonymousExportView | String | Provides access to the anonymous export view of the comment body, which can be expanded to show public exportable content. | ||
| BodyExpandableEditor | String | Links to the editor view of the comment body, allowing access to the content in an editable format. | ||
| BodyExpandableExportView | String | Provides a link to the export view representation of the comment body, used when exporting or rendering content externally. | ||
| BodyExpandableStorage | String | Links to the storage representation of the comment body, which contains the raw data in Confluence Storage Format. | ||
| BodyExpandableStyledView | String | Provides access to the styled view of the comment body, showing formatted content as rendered in the Confluence interface. | ||
| BodyViewExpandableContent | String | Links to the view representation of the comment's main content, used for display purposes. | ||
| BodyViewExpandableWebresource | String | Links to associated web resources, such as embedded media or macros, included in the comment body. | ||
| BodyViewRepresentation | String | Specifies the current representation type of the comment body, such as view or storage. | ||
| BodyViewValue | String | Contains the actual text content of the comment in its rendered form. | ||
| ExtensionsExpandableResolution | String | Provides a link to additional resolution-related extensions, such as comment status or resolution metadata. | ||
| ExtensionsLocation | String | Indicates the location context of the comment within the page, such as inline or section-based placement. | ||
| Status | String | Indicates the current status of the comment, such as active, resolved, or deleted. | ||
| Title | String | The title or first line of the comment, often used as a summary or identifier in lists. | ||
| Type | String | Specifies the content type, indicating that this record represents a comment. | ||
| PageId | String |
Pages.Id | =,!=,IN,NOT_IN | The unique identifier of the page that contains this comment. |