Approval search fields

Approval writes 13 fields into Confluence's own search index. Once a page has been indexed you can filter and sort by them in Capable Search, and use them in ordinary Confluence CQL.

Search results with the page details panel open, showing an Approved approval with its approver, and the Publishing section below it — The Approval section on the right carries the same state the fields record, including the current status and who has responded.

A page Confluence has not indexed yet carries no values at all. It does not match a query on these fields, and it does not come back as an empty result either. On a large site indexing takes hours to days to catch up.

The <hash> prefix is your installation's app hash. Field names are written with it, so the exact string differs per site. Use the Copy CQL action in the search table rather than typing it.

#The fields

Field	What it holds
<hash>_capable_approval_status	Current approval state of the page. Use a plain number with no quotes, for example `<hash>_capable_approval_status = 0`. It is also the default sort field for the built-in 'Pending approvals' and 'Your approvals' searches.
<hash>_capable_approval_created_by	Account ID of the person who raised the approval request. Example: `<hash>_capable_approval_created_by = currentUser()`. This is the 'Your approvals' query.
<hash>_capable_approval_pending	Account IDs of approvers who have not yet responded. `= currentUser()` is the 'waiting on me' query.
<hash>_capable_approval_approved	Account IDs of users who approved.
<hash>_capable_approval_rejected	Account IDs of users who rejected.
<hash>_capable_approval_commented	Account IDs of users who left a comment on the approval without approving or rejecting.
<hash>_capable_approval_latest_version_by	Account ID of whoever created the page version the approval is attached to. This field never appears in the CQL editor's field list, so you cannot search on it eve
<hash>_capable_approval_is_complete	Whether the approval reached a final state. The value is text rather than true or false, and like latest_version_by the field is not offered in autocomplete.
<hash>_capable_approval_created_at	When the approval was raised, as a Unix timestamp in milliseconds with no quotes. Example: `>= 1735689600000`.
<hash>_capable_approval_completed_at	When the approval reached a final state (approved or rejected), as a Unix timestamp in milliseconds.
<hash>_capable_approval_last_response_at	Most recent approver response on the approval, as a Unix timestamp in milliseconds. Good for finding stalled approvals.
<hash>_capable_approval_expires_at	When the approval is scheduled to expire, as a Unix timestamp in milliseconds. The default operator is `<`, meaning expiring before a date.
<hash>_capable_approval_expired_at	When the approval actually expired (as opposed to when it was due to), as a Unix timestamp in milliseconds.

Capable core search fields

10 fields.

Asset library search fields

10 fields.

Capable search fields

Every field, and how they work.

Indexed, then searchable. In that order.