In this page
Overview
This page lists sample CQL queries for common use cases around content ownership. They're completely standard CQL queries, so you can use them as-is, adapt them to your own needs, or freely combine them with any other CQL field or function for more complex searches.
Query samples
Any owner
Contents that have owners, either directly or through inheritance:
arch.anyOwner.count > 0
Contents that have no owner:
type in (page,blogpost) and not arch.anyOwner.count > 0
(The otherwise useless clause on the "type" field is needed only because a negative expression cannot be the first clause in CQL.)
Contents owned by me, either directly or through inheritance:
arch.anyOwner = currentUser()
Contents owned by a specific user, either directly or through inheritance:
arch.anyOwner = "123abcde95673300697be2ba"
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Contents that have owners changed this week:
arch.anyOwner.count > 0 and arch.anyOwner.setOn > startOfWeek()
Direct owner
Contents owned by a specific user directly:
arch.directOwner = "123abcde95673300697be2ba"
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Contents owned directly by exactly 2 users:
arch.directOwner.count = 2
Contents with direct owners set this week:
arch.directOwner.setOn > startOfWeek()
Inherited owner
Contents owned by a specific user through inheritance:
arch.inheritedOwner = "123abcde95673300697be2ba"
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Contents owned through inheritance by exactly 2 users:
arch.inheritedOwner.count = 2
Contents owned through inheritance set this week:
arch.inheritedOwner.setOn > startOfWeek()
Owner
Contents owned by a specific user:
arch.owner = "123abcde95673300697be2ba"
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Contents owned by at least 2 users:
arch.owner.count >= 2
Who
Contents with owners, that are not inherited by their descendants, set by a specific user:
arch.owner.setBy = "123abcde95673300697be2ba"
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Contents with owners, that are not inherited by their descendants, set by specific users:
arch.owner.setBy in ("123abcde95673300697be2ba", "456fabcd1238456789abcdef")
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Contents with owners, that are not inherited by their descendants, set by me:
arch.owner.setBy = currentUser()
When
Contents with owners, that are not inherited by their descendants, set before a specific date:
arch.owner.setOn < "2026-08-01"
Contents with owners, that are not inherited by their descendants, set in a specific period:
arch.owner.setOn > "2026-01-15" and arch.owner.setOn < "2026-08-01"
Contents with owners, that are not inherited by their descendants, set today:
arch.owner.setOn >= startOfDay()
Tree owner
Contents owned by a specific user with ownership inherited by their descendants, set this week:
arch.treeOwner = "123abcde95673300697be2ba" and arch.treeOwner.setOn > startOfWeek()
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Roots of content trees with tree owners (that are inherited by their descendants):
arch.treeOwner.count > 0
Who
Roots of content trees with tree owners (that are inherited by their descendants) set by a specific user:
arch.treeOwner.setBy = "123abcde95673300697be2ba"
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Roots of content trees with tree owners (that are inherited by their descendants) set by specific users:
arch.treeOwner.setBy in ("123abcde95673300697be2ba", "456fabcd1238456789abcdef")
(The alphanumeric string is the user's Atlassian account ID. How to figure out?)
Roots of content trees with tree owners (that are inherited by their descendants) set by me:
arch.treeOwner.setBy = currentUser()
When
Roots of content trees with tree owners (that are inherited by their descendants) set before a specific date:
arch.treeOwner.setOn < "2026-08-01"
Roots of content trees with tree owners (that are inherited by their descendants) set in a specific period:
arch.treeOwner.setOn > "2026-01-15" and arch.treeOwner.setOn < "2026-08-01"
Roots of content trees with tree owners (that are inherited by their descendants) set today:
arch.treeOwner.setOn >= startOfDay()
Questions?
Ask us any time.