PageAncestors
Displays the parent hierarchy of a page, showing how the current page is positioned within the overall content structure.
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 unique identifier of the ancestor page within the Confluence hierarchy. | ||
| ExpandableAncestors | String | Provides a reference to additional ancestor pages that can be expanded to view the full hierarchy above the current page. | ||
| ExpandableBody | String | Links to the expandable section containing the page's body content, allowing access to detailed text data when requested. | ||
| ExpandableChildren | String | Links to the expandable section listing the direct child pages of the ancestor, enabling traversal down the hierarchy. | ||
| ExpandableChildTypes | String | Specifies the available types of child content that can be expanded under the ancestor page, such as page or comment. | ||
| ExpandableContainer | String | Provides a reference to the container element, such as a space, that holds the ancestor page. | ||
| ExpandableDescendants | String | Links to a list of all descendant pages that can be expanded from this ancestor, showing the entire subpage structure. | ||
| ExpandableHistory | String | Links to historical data about the ancestor page, including previous versions and edits. | ||
| ExpandableMetadata | String | Links to the expandable section containing metadata for the ancestor page, such as labels and properties. | ||
| ExpandableOperations | String | Lists available operations that can be performed on the ancestor page, such as view or edit. | ||
| ExpandableRestrictions | String | Links to the access restrictions applied to the ancestor page, including view and edit permissions. | ||
| ExpandableSchedulePublishDate | Datetime | Specifies the scheduled date and time when the ancestor page is set to be published, if applicable. | ||
| ExpandableSpace | String | Provides a link to the space that contains the ancestor page, allowing retrieval of related space information. | ||
| ExpandableVersion | String | Links to version details of the ancestor page, including version number and author information. | ||
| LinksEditui | String | The URL of the edit interface (EditUI) for the ancestor page, allowing users to modify its content. | ||
| LinksSelf | String | The self-referential API link (Self link) for the ancestor page, used to retrieve its data programmatically. | ||
| LinksTinyui | String | The short link (TinyUI) version of the ancestor page's URL, providing a compact link for easy sharing. | ||
| LinksWebui | String | The standard web interface URL (WebUI) of the ancestor page, used for navigation in Confluence. | ||
| ExtensionsPosition | String | Indicates the page's position within its parent hierarchy, defining its placement order among sibling pages. | ||
| Status | String | Indicates the publication status of the ancestor page, such as current, draft, or archived. | ||
| Title | String | The title of the ancestor page as displayed in Confluence. | ||
| Type | String | Specifies the content type, indicating that this record represents a page ancestor. | ||
| PageId [KEY] | String |
Pages.Id | =,!=,IN,NOT_IN | The unique identifier of the current page whose ancestor information is being retrieved. |