Problem Definition

As of today there is no field or function in Confluence Query Language (CQL) to identify pages that do or do not have child pages as per Advanced searching using CQL.

Notice that the Ancestor and Parent fields will return a list of results for a specific Page ID rather than a filter to all contents.

This would be helpful to identify pages with no children that can be safely archived without disrupting the Parent-Child relation, since archiving a parent page will automatically move all children one level up.

Suggested Solution

Implement a isParent and/or hasChildren field / function that returns a list of contents that either match or do not match the condition.

Workaround

Confluence Automation does have a {{page.hasChildren}} Smart Value that can be used as a Condition.