JDBC Driver for Confluence

Build 22.0.8462

PageComments

Get comments specific to a page.

Table Specific Information

Select

The driver 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 Id of the comments mentioned in the Page.
ExpandableAncestors String The ExpandableAncestors of the page comments.
ExpandableChildren String The ExpandableChildren of the page comments.
ExpandableContainer String The ExpandableContainer of the page comments.
ExpandableDescendants String The ExpandableDescendants of the page comments.
ExpandableHistory String The ExpandableHistory of the page comments.
ExpandableMetadata String The ExpandableMetadata of the page comments.
ExpandableOperations String The ExpandableOperations of the page comments.
ExpandableRestrictions String The ExpandableRestrictions of the page comments.
ExpandableSpace String The ExpandableSpace of the page comments.
ExpandableVersion String The ExpandableVersion of the page comments.
LinksSelf String The LinksSelf of the page comments.
LinksWebui String The LinksWebui of the page comments.
BodyExpandableAnonymousExportView String The BodyExpandableAnonymousExportView of the page comments.
BodyExpandableEditor String The BodyExpandableEditor of the page comments.
BodyExpandableExportView String The BodyExpandableExportView of the page comments.
BodyExpandableStorage String The BodyExpandableStorage of the page comments.
BodyExpandableStyledView String The BodyExpandableStyledView of the page comments.
BodyViewExpandableContent String The BodyViewExpandableContent of the page comments.
BodyViewExpandableWebresource String The BodyViewExpandableWebresource of the page comments.
BodyViewRepresentation String The BodyViewRepresentation of the page comments.
BodyViewValue String The BodyViewValue of the page comments.
ExtensionsExpandableResolution String The ExtensionsExpandableResolution of the page comments.
ExtensionsLocation String The ExtensionsLocation of the page comments.
Status String The Status of the page comments.
Title String The Title of the page comments.
Type String The Type of the page comments.
PageId String

Pages.Id

=,IN Pseudo column: The Id of the page.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462