FLINT TABLE FILTER · USE CASE
Review requirements for a release without losing the master table
Release reviews need a narrow slice of a long requirements matrix. Show one release, keep only the requirements that still lack verification or evidence, and save that review without copying or editing the master table.
What you will end with: from 28 requirements, the 14 planned for release 2026-R4, and of those the 7 gaps: six not yet verified and one marked Verified with no evidence link. The view is saved for the next review, and the matrix stays complete for everyone else.
Before you start
The matrix records each requirement’s release, component, owner, status and a link to its test evidence. Statuses and links are maintained by people. Flint Table Filter does not synchronize with Jira, compute traceability or check that an evidence link works.
Sample matrix: requirements-matrix.csv · 28 rows, 7 columns, fictional data.
| Req ID | Requirement | Release | Component | Owner | Status | Evidence |
|---|---|---|---|---|---|---|
| REQ-001 | Users can reset a password from the sign-in page | 2026-R3 | Accounts | Maya Patel | Verified | https://qa.example.com/runs/0400 |
| REQ-002 | Admins can export the audit log as CSV | 2026-R4 | Admin | Ines Duarte | Implemented | (blank) |
| REQ-003 | Invoices show tax per line item | 2026-R4 | Billing | Diego Alvarez | Verified | https://qa.example.com/runs/0406 |
| REQ-004 | Search returns results within two seconds for 10,000 records | 2027-R1 | Search | Chen Wei | Draft | (blank) |
| REQ-005 | Users can switch between light and dark themes | 2026-R3 | Interface | Maya Patel | Verified | https://qa.example.com/runs/0412 |
Show all 28 rows
| Req ID | Requirement | Release | Component | Owner | Status | Evidence |
|---|---|---|---|---|---|---|
| REQ-001 | Users can reset a password from the sign-in page | 2026-R3 | Accounts | Maya Patel | Verified | https://qa.example.com/runs/0400 |
| REQ-002 | Admins can export the audit log as CSV | 2026-R4 | Admin | Ines Duarte | Implemented | (blank) |
| REQ-003 | Invoices show tax per line item | 2026-R4 | Billing | Diego Alvarez | Verified | https://qa.example.com/runs/0406 |
| REQ-004 | Search returns results within two seconds for 10,000 records | 2027-R1 | Search | Chen Wei | Draft | (blank) |
| REQ-005 | Users can switch between light and dark themes | 2026-R3 | Interface | Maya Patel | Verified | https://qa.example.com/runs/0412 |
| REQ-006 | Failed payments trigger a retry after 24 hours | 2026-R4 | Billing | Ines Duarte | Verified | https://qa.example.com/runs/0415 |
| REQ-007 | Admins can require two-step verification | 2026-R4 | Accounts | Diego Alvarez | Implemented | (blank) |
| REQ-008 | Notifications respect quiet hours | 2027-R1 | Notifications | Chen Wei | Draft | (blank) |
| REQ-009 | Search highlights matching words | 2026-R3 | Search | Maya Patel | Verified | https://qa.example.com/runs/0424 |
| REQ-010 | Users can download their data | 2026-R4 | Accounts | Ines Duarte | Verified | (blank) |
| REQ-011 | Admins can restrict sign-in by email domain | 2026-R4 | Admin | Diego Alvarez | Verified | https://qa.example.com/runs/0430 |
| REQ-012 | Receipts are emailed after each payment | 2027-R1 | Billing | Chen Wei | Draft | (blank) |
| REQ-013 | Keyboard users can reach every menu item | 2026-R3 | Interface | Maya Patel | Verified | https://qa.example.com/runs/0436 |
| REQ-014 | Notification emails include an unsubscribe link | 2026-R4 | Notifications | Ines Duarte | Implemented | https://qa.example.com/runs/0461 |
| REQ-015 | Saved searches can be shared with a team | 2026-R4 | Search | Diego Alvarez | Verified | https://qa.example.com/runs/0442 |
| REQ-016 | Admins can review active sessions | 2027-R1 | Admin | Chen Wei | Draft | (blank) |
| REQ-017 | Users can change the display language | 2026-R3 | Interface | Maya Patel | Verified | https://qa.example.com/runs/0448 |
| REQ-018 | Credit notes reference the original invoice | 2026-R4 | Billing | Ines Duarte | Verified | https://qa.example.com/runs/0451 |
| REQ-019 | Mobile push notifications can be muted per project | 2026-R4 | Notifications | Diego Alvarez | Implemented | (blank) |
| REQ-020 | Inactive accounts are flagged after 90 days | 2027-R1 | Accounts | Chen Wei | Draft | (blank) |
| REQ-021 | Admins can schedule maintenance banners | 2026-R3 | Admin | Maya Patel | Verified | https://qa.example.com/runs/0460 |
| REQ-022 | Search supports quoted phrases | 2026-R4 | Search | Ines Duarte | Implemented | (blank) |
| REQ-023 | Error messages explain the next step | 2026-R4 | Interface | Diego Alvarez | Verified | https://qa.example.com/runs/0466 |
| REQ-024 | Billing contacts can be different from account owners | 2027-R1 | Billing | Chen Wei | Draft | (blank) |
| REQ-025 | Users can pause email digests | 2026-R3 | Notifications | Maya Patel | Verified | https://qa.example.com/runs/0472 |
| REQ-026 | Admins can bulk deactivate users | 2026-R4 | Admin | Ines Duarte | Verified | https://qa.example.com/runs/0475 |
| REQ-027 | Search results can be filtered by date | 2026-R4 | Search | Diego Alvarez | Implemented | (blank) |
| REQ-028 | Session timeout warns before sign-out | 2027-R1 | Accounts | Chen Wei | Draft | (blank) |
- Edit a Confluence page and insert the Flint Table Filter macro.
- Inside the macro, add a native Confluence table whose first row is a header row with the column names from requirements-matrix.csv, then enter or paste the data rows. If you paste from a spreadsheet, check that the result is an editable Confluence table rather than an image or an embedded file.
- Publish the page. Search, Filters, Sort, Columns, Summary, Export, Expand table and Reset view appear above the published table.
Step 1: Show one release
- Choose Filters, then Release. With few distinct values the column offers Is one of with a dropdown.
- In Matching values, choose 2026-R4. The value list shows 7 rows for 2026-R3, 14 for 2026-R4 and 7 for 2027-R1.
- Choose Done. The count line reads 14 of 28 rows.
For a quick status picture, open Summary and set Group rows by to Status: 8 Verified and 6 Implemented.
Step 2: Keep only the gaps
A requirement is a gap if it is not verified or it has no evidence link. Those two conditions use different columns, so they go in one advanced group that matches any rule.
- Choose Advanced groups, then Add group. Create the rule Status, Text, Does not equal,
Verified, and choose Save rule. - Set Match rules in group 1 to Any rule (OR).
- Choose Add rule to group 1. Create the rule Evidence, Text, Is empty, and choose Save rule, then Done.
The Release filter still applies, so the table shows 7 of 28 rows.
| Req ID | Requirement | Component | Owner | Status | Evidence |
|---|---|---|---|---|---|
| REQ-002 | Admins can export the audit log as CSV | Admin | Ines Duarte | Implemented | (blank) |
| REQ-007 | Admins can require two-step verification | Accounts | Diego Alvarez | Implemented | (blank) |
| REQ-010 | Users can download their data | Accounts | Ines Duarte | Verified | (blank) |
| REQ-014 | Notification emails include an unsubscribe link | Notifications | Ines Duarte | Implemented | https://qa.example.com/runs/0461 |
| REQ-019 | Mobile push notifications can be muted per project | Notifications | Diego Alvarez | Implemented | (blank) |
| REQ-022 | Search supports quoted phrases | Search | Ines Duarte | Implemented | (blank) |
| REQ-027 | Search results can be filtered by date | Search | Diego Alvarez | Implemented | (blank) |
Two rows show why both rules matter. REQ-014 already has a test run linked but is still Implemented, so the status rule catches it. REQ-010 is marked Verified but nothing is linked, so only the evidence rule catches it.
Step 3: Tidy and save the review
- Choose Columns and clear Release; every visible row has the same value. The column still filters while hidden.
- Sort by Owner so each person can find their rows.
- Open Saved views and presentation, enter
2026-R4 evidence gapsin View name and choose Save personal view.
Next time, choose Personal: 2026-R4 evidence gaps in Reader view and Apply view. As owners link evidence and mark rows Verified in the source table, the list shrinks. To give QA the same list, prepare it as a shared view.
Hand off the gap list
Choose Export with Current result to download the seven rows as CSV or XLSX for a release checklist. Evidence links export as their link text. See CSV and Excel exports for what the files contain.
What to know
- Evidence cells containing an ordinary link stay clickable in the interactive table. Filters and search compare the text Confluence stores for the link.
- The next release is one filter change away: choose 2027-R1 instead and keep the same gap rule.
- Filtering does not restrict who can read requirements. The whole matrix stays in the page and in Confluence PDF and Word exports.