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.

The Approval panel in a search side panel, under a Capabilities heading, showing a purple Pending bar, counts of 0 of 1 approved and 0 of 1 rejected, and Jack Graves listed under Pending with a Respon — The approval panel on a result carries the same state the fields record, including the current status and who has yet to respond.

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. Value must be a BARE number. Example: `<hash>_capable_approval_status = 0`. 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. Unix MILLISECONDS, bare number. Example: `>= 1735689600000`.
<hash>_capable_approval_completed_at	When the approval reached a final state (approved or rejected). Unix milliseconds.
<hash>_capable_approval_last_response_at	Most recent approver response on the approval. Unix milliseconds. Good for finding stalled approvals.
<hash>_capable_approval_expires_at	The instant the approval is scheduled to expire. Unix 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). Unix 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.