PageChildrens
To look at a page hierarchy including who is the child 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 PageChildrens view.
- PageId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PageChildrens WHERE PageId = '33106'
SELECT * FROM PageChildrens WHERE PageId IN ('163902', '33106')
Columns
| Name | Type | References | SupportedOperators | Description |
| Id [KEY] | String | The Id of the PageChildrens. | ||
| ExpandableAncestors | String | The ExpandableAncestors of the PageChildrens. | ||
| ExpandableBody | String | The ExpandableBody of the PageChildrens. | ||
| ExpandableChildren | String | The ExpandableChildren of the PageChildrens. | ||
| ExpandableChildTypes | String | The ExpandableChildTypes of the PageChildrens. | ||
| ExpandableContainer | String | The ExpandableContainer of the PageChildrens. | ||
| ExpandableDescendants | String | The ExpandableDescendants of the PageChildrens. | ||
| ExpandableHistory | String | The ExpandableHistory of the PageChildrens. | ||
| ExpandableMetadata | String | The ExpandableMetadata of the PageChildrens. | ||
| ExpandableOperations | String | The ExpandableOperations of the PageChildrens. | ||
| ExpandableRestrictions | String | The ExpandableRestrictions of the PageChildrens. | ||
| ExpandableSchedulePublishDate | Datetime | The ExpandableSchedulePublishDate of the PageChildrens. | ||
| ExpandableSpace | String | The ExpandableSpace of the PageChildrens. | ||
| ExpandableVersion | String | The ExpandableVersion of the PageChildrens. | ||
| LinksEditui | String | The LinksEditui of the PageChildrens. | ||
| LinksSelf | String | The LinksSelf of the PageChildrens. | ||
| LinksTinyui | String | The LinksTinyui of the PageChildrens. | ||
| LinksWebui | String | The LinksWebui of the PageChildrens. | ||
| ExtensionsPosition | String | The ExtensionsPosition of the PageChildrens. | ||
| Status | String | The Status of the PageChildrens. | ||
| Title | String | The Title of the PageChildrens. | ||
| Type | String | The Type of the PageChildrens. | ||
| PageId | String |
Pages.Id | =,!=,IN,NOT IN | The Id of the page. |