Discrepancy counting descendant pages between CQL and REST - Confluence Cloud - The Atlassian Developer Community

I have two sets of page hierarchies that look like this: If I call the REST API wiki/rest/api/content/R1/descendant/page, or if I execute a CQL search with ancestor=R1 AND type IN ( page ) I get the pages One, Two, and Three back as expected. If I move R2 to be an immediate child of R1, the same REST API call returns all expected pages. However, the same SQL search returns pages One, Two, Three, and R2; missing are Four, Five and Six. Am I searching incorrectly, or do I have incorrect expec

Solved: ScriptRunner for Confluence selective bulk deletio

Confluence 2.7 Release Notes Confluence Data Center and Server

Solved: CQL Query for Page Status

Understanding Permission in Confluence, Confluence

Confluence 5.9 Release Notes Confluence Data Center and Server

Built-In Scripts

Confluence 8.0 beta release notes

Solved: How can I make inactive users searchable in Conflu

Revamping Confluence Cloud Search - Atlassian Engineering

Current user not permitted to use Confluence error when getting

Page Properties Macro Confluence Data Center and Server 8.7

Version History - Better Content Archiving for Confluence