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