# 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](https://help.gocapable.com/images/77627b02-ff76-4ead-8507-a20d5883c070.webp)

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.                                                                                                                            |

---

## Related

[Capable core search fields10 fields.](https://help.gocapable.com/search/capable-core-search-fields.html)

[Asset library search fields10 fields.](https://help.gocapable.com/search/asset-library-search-fields.html)

[Capable search fieldsEvery field, and how they work.](https://help.gocapable.com/search/capable-search-fields.html)

---

_Indexed, then searchable. In that order._