JDBC Driver for Confluence

Build 22.0.8462

PageAncestors

To look at a page hierarchy including who is the parent 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 PageAncestors view.

  • PageId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PageAncestors WHERE PageId = '33106'
SELECT * FROM PageAncestors WHERE PageId IN ('163902','33106')

Columns

Name Type References SupportedOperators Description
Id [KEY] String The Id of the PageAncestors.
ExpandableAncestors String The ExpandableAncestors of the PageAncestors.
ExpandableBody String The ExpandableBody of the PageAncestors.
ExpandableChildren String The ExpandableChildren of the PageAncestors.
ExpandableChildTypes String The ExpandableChildTypes of the PageAncestors.
ExpandableContainer String The ExpandableContainer of the PageAncestors.
ExpandableDescendants String The ExpandableDescendants of the PageAncestors.
ExpandableHistory String The ExpandableHistory of the PageAncestors.
ExpandableMetadata String The ExpandableMetadata of the PageAncestors.
ExpandableOperations String The ExpandableOperations of the PageAncestors.
ExpandableRestrictions String The ExpandableRestrictions of the PageAncestors.
ExpandableSchedulePublishDate Datetime The ExpandableSchedulePublishDate of the PageAncestors.
ExpandableSpace String The ExpandableSpace of the PageAncestors.
ExpandableVersion String The ExpandableVersion of the PageAncestors.
LinksEditui String The LinksEditui of the PageAncestors.
LinksSelf String The LinksSelf of the PageAncestors.
LinksTinyui String The LinksTinyui of the PageAncestors.
LinksWebui String The LinksWebui of the PageAncestors.
ExtensionsPosition String The ExtensionsPosition of the PageAncestors.
Status String The Status of the PageAncestors.
Title String The Title of the PageAncestors.
Type String The Type of the PageAncestors.
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