PageAncestors
To look at a page hierarchy including who is the parent page.
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 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,NOT IN | The Id of the page. |