Columns
The search table's columns are the union of whatever capabilities you have installed. Search itself contributes the obvious ones; everything else arrives because another capability wrote it into the index.
That is why the table gets richer as you install more, and why the standalone app has the fewest.
#Every column
Column | What it shows |
|---|---|
ID | The Confluence content id of the row. |
Title | Page title with icon; editable in place to rename the page (text editor). |
Created by | Avatar of the page creator. |
Version | Current version number. |
Mentions | Users @mentioned in the page body. Needs the page body, so it forces the heavier body expansion on the search. |
Collaborators | Avatars of contributors/publishers. |
Labels | Page labels. |
Space | Space the page lives in. |
Last updated | Timestamp of the latest version. |
Created | Page creation timestamp. |
Attachments | Count of attachments on the page. |
State | Confluence content state chip. Fetched per row with its own API call, and exports as an empty cell. |
Status | Content status; editable in place via a status picker. |
Intel | Icon strip of heuristics: page size (Empty/Tiny/Small/Long page) and staleness (Recently updated through Not updated in over a year). Exports as an empty cell. |
Paragraphs | Paragraph count computed from the page body. |
Words | Word count computed from the page body. |
Characters | Character count computed from the page body. |
Raised By | Who raised the approval request. |
Approval Status | Progress bar of the approval. |
Assigned | All assigned approvers. |
Rejected | Approvers who rejected. |
Approved | Approvers who approved. |
Reviewing | Approvers still pending. |
Commented | Approvers who commented without deciding. |
Created at | When the approval was raised. |
Expires at | Approval expiry instant. |
Last response | Most recent response. Note the stored header name begins with a stray leading space. |
Completed at | When the approval reached a final state. |
Approved on | When approval was granted. |
Raised By (Email) | Email variant of Raised By. Opt-in only, never in a default column set. |
Assigned (Email) | Email variant of Assigned. |
Created By (Email) | Email variant of Created By. |
Rejected (Email) | Email variant of Rejected. |
Approved (Email) | Email variant of Approved. |
Reviewing (Email) | Email variant of Reviewing. |
Commented (Email) | Email variant of Commented. |
Files | Count of GitHub files referenced on the page. |
Repositories | GitHub repositories referenced. |
Organizations | GitHub owners/organisations referenced. |
File Types | File extensions referenced. |
Overview | Combined publishing summary chip. |
Approvers | Approvers on the publish request. |
Method | How the page was published. |
Publisher | Who published it. |
Published at | Publish timestamp. |
Quality | Count of quality issues flagged on the page. |
SEO Title | Site SEO title override for the page. |
SEO Description | Site SEO description override. |
SEO Slug | Site URL slug override. |
Cover Image | Whether a cover image is set; exports as Yes/No. |
Links | Count of links in the page. |
Dates | Dates detected on the page. |
Text | Full-text match; emits `text ~ "…"`. A blank or whitespace-only value contributes nothing. |
Space | Restrict to one or more spaces. |
Contributors | Pages a given user contributed to; emits `contributor`. |
Created | Creation-date range. |
Updated | Last-modified date range. |
Mentions | Pages mentioning a given user. |
Favorited by | Pages favourited by a given user; emits `favorite IN (…)`, which Confluence accepts as an alias of `favourite`. |
Ancestor | Anything beneath a chosen page at any depth. |
Parent | Direct children of a chosen page only. |
Creator | Pages created by a given user. |
Labels | Pages carrying any of the chosen labels. |
Apps | Pages using a third-party vendor's macro, resolved through the migration schema so each vendor's own CQL shape is used. |
Raised by | Approvals raised by a user. |
Approvers | Approvals assigned to a user. |
In Review | Approvals still pending a user's response. |
Approved | Approvals a user approved. |
Rejected | Approvals a user rejected. |
Status | Approval status: 0=pending, 1=approved, 2=rejected. |
Expiry | Approvals expiring in a date range. |
Created at | Approval creation date range. |
Completed at | Approval completion date range. |
Last response at | Date range of the most recent response. |
Expired | Approvals that actually expired. |
Minimum Files | Pages referencing at least N GitHub files. |
Repository | Pages referencing a given owner/name repository. |
Organization | Pages referencing a GitHub organisation. |
File Type | Pages referencing a given file extension. |
Published | Publish-date range. |
Columns are per saved search. Changing which are visible and saving writes that back onto the saved search, so everyone using it sees the change.
#A few things worth knowing
A column whose capability is not installed simply is not offered.
Sorting on a Capable field only orders pages that have been indexed.
Column choices travel with a saved search, including into the macros.
#Related
The table grows with what you install.
