# Search and reporting One page at a time is fine until somebody asks what is still waiting on legal, or which policies expire this quarter. Capable Search turns approval state into something you can filter, sort, report on and export, across every space at once. ℹī¸ This needs the Search capability, which the suite includes and the standalone app does not. See [Plans and pricing](https://help.gocapable.com/approval/plans-and-pricing.html). --- ## Two searches you get for free Two ready-made views appear in the catalogue as soon as Approval is installed. | **Search** | **Shows** | | --------------------- | ---------------------------------------- | | **Your approvals** | Everything you raised. | | **Pending approvals** | Everything still waiting for a response. | Both show 25 rows. For a busy space that will not be everything, so build your own once you outgrow them. --- ## Building your own view Add any approval column from the column picker and any approval filter from the filter bar. There are **19 columns** and **12 filters**. ![image-20260905-060956.png](https://help.gocapable.com/images/eb191a3c-bd57-4203-b88d-a12d550ae49e.webp) | **Group** | **Columns** | | ---------- | ------------------------------------------------------------------------- | | **People** | Raised by, Assigned, Created by, Approved, Rejected, Reviewing, Commented | | **State** | Approval status | | **Dates** | Created at, Expires at, Last response, Completed at, Approved on | 📝 Every people column also has an **email version**, which is what you usually want in an export going to somebody outside Confluence. They are hidden by default, so add them from the column picker. ### What to sort by Four sort fields: approval created at, expires at, status, and last response. Sorting by **expires at** gives you the what-lapses-next list that most quality teams end up running as a standing report. See [Expiry and re-approval](https://help.gocapable.com/approval/expiry-and-re-approval.html). --- ## Responding without leaving the results Click any row and the side panel opens with an **Approval** tab holding the same control you get under a page title. You can raise or answer an approval without ever opening the page. The tab also carries a badge showing that page state, including whether the approval still matches the page version it was given for. See [What is recorded](https://help.gocapable.com/approval/what-is-recorded.html). --- ## Answering several pages at once Tick two or more rows and an action bar appears offering **Approve**, **Reject** and **Comment** across the whole selection, with a progress bar and a per-page result at the end. ![image-20260905-061039.png](https://help.gocapable.com/images/bb4fbca1-1f32-4ec0-9aa0-6478bcb7586e.webp) | **Situation** | **What happens** | | --------------------------------------------- | ---------------- | | You are not an approver on some selected rows | PARTIAL | | The space requires a code to approve | ALL FAIL | The buttons appear for every selected row whether or not you can act on it, so pages you cannot answer fail individually and are listed at the end rather than being greyed out up front. ⚠ī¸ Bulk actions cannot collect a two factor code, so in a space that requires one **every page in the batch fails**. Answer individually in those spaces. See [Sign approvals with a code](https://help.gocapable.com/approval/sign-approvals-with-a-code.html). --- ## Writing it in CQL Eleven approval fields are queryable, so you can write exactly the query you want, or describe it in words in Search Studio and let it write the CQL for you. ![image-20260905-061133.png](https://help.gocapable.com/images/a92f855b-7ea4-4766-a842-00469abe0640.webp) | **Field type** | **Values and operators** | | -------------- | ------------------------------------------------------ | | Status | 0 pending, 1 approved, 2 rejected | | People | Account ids, with \= and IN, so \= currentUser() works | | Dates | Timestamps, with the usual comparison operators | ⚠ī¸ Field names carry a prefix unique to your site, such as `njyzjq_capable_approval_status`. A query copied from another Confluence site will not run until the prefix is changed to match yours. --- ## Scanning a space without building anything The **Manage** view shows content as a page tree with an approval status column already switched on. It is often the fastest way to see how a space is doing before you go near a saved search. The dashboard alternative is in [Track approvals](https://help.gocapable.com/approval/track-approvals.html). --- ## A few things that catch people out * A brand new approval will not appear until Confluence has indexed it. Give it a moment. * The status column is narrow by design, so a long approver list is truncated on screen. The full list is in the export. * Exports write plain text rather than the avatars you see, which is what you want for a spreadsheet. * The export does not mark which responses were signed, so it is not on its own evidence of signature. See [Compliance](https://help.gocapable.com/approval/compliance.html). --- ## Related [Expiry and re-approvalBuilding the expiring-soon report.](https://help.gocapable.com/approval/expiry-and-re-approval.html) [Track approvalsThe dashboard and the inbox.](https://help.gocapable.com/approval/track-approvals.html) [What is recordedWhat the export can and cannot evidence.](https://help.gocapable.com/approval/what-is-recorded.html) [Sign approvals with a codeWhy bulk actions fail in signed spaces.](https://help.gocapable.com/approval/sign-approvals-with-a-code.html) [Respond to a requestAnswering one request properly.](https://help.gocapable.com/approval/respond-to-a-request.html) [ComplianceWhat an auditor will ask you to produce.](https://help.gocapable.com/approval/compliance.html) --- _One query, and the whole site answers you._