PageComments
Retrieves all comments made on a particular page, including text content, authors, and creation dates.
Table Specific Information
Select
The add-in 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. |