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