BlueConfetti

Guides / Flint Table Filter

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.

First 5 rows
Req IDRequirementReleaseComponentOwnerStatusEvidence
REQ-001Users can reset a password from the sign-in page2026-R3AccountsMaya PatelVerifiedhttps://qa.example.com/runs/0400
REQ-002Admins can export the audit log as CSV2026-R4AdminInes DuarteImplemented(blank)
REQ-003Invoices show tax per line item2026-R4BillingDiego AlvarezVerifiedhttps://qa.example.com/runs/0406
REQ-004Search returns results within two seconds for 10,000 records2027-R1SearchChen WeiDraft(blank)
REQ-005Users can switch between light and dark themes2026-R3InterfaceMaya PatelVerifiedhttps://qa.example.com/runs/0412
Show all 28 rows
Req IDRequirementReleaseComponentOwnerStatusEvidence
REQ-001Users can reset a password from the sign-in page2026-R3AccountsMaya PatelVerifiedhttps://qa.example.com/runs/0400
REQ-002Admins can export the audit log as CSV2026-R4AdminInes DuarteImplemented(blank)
REQ-003Invoices show tax per line item2026-R4BillingDiego AlvarezVerifiedhttps://qa.example.com/runs/0406
REQ-004Search returns results within two seconds for 10,000 records2027-R1SearchChen WeiDraft(blank)
REQ-005Users can switch between light and dark themes2026-R3InterfaceMaya PatelVerifiedhttps://qa.example.com/runs/0412
REQ-006Failed payments trigger a retry after 24 hours2026-R4BillingInes DuarteVerifiedhttps://qa.example.com/runs/0415
REQ-007Admins can require two-step verification2026-R4AccountsDiego AlvarezImplemented(blank)
REQ-008Notifications respect quiet hours2027-R1NotificationsChen WeiDraft(blank)
REQ-009Search highlights matching words2026-R3SearchMaya PatelVerifiedhttps://qa.example.com/runs/0424
REQ-010Users can download their data2026-R4AccountsInes DuarteVerified(blank)
REQ-011Admins can restrict sign-in by email domain2026-R4AdminDiego AlvarezVerifiedhttps://qa.example.com/runs/0430
REQ-012Receipts are emailed after each payment2027-R1BillingChen WeiDraft(blank)
REQ-013Keyboard users can reach every menu item2026-R3InterfaceMaya PatelVerifiedhttps://qa.example.com/runs/0436
REQ-014Notification emails include an unsubscribe link2026-R4NotificationsInes DuarteImplementedhttps://qa.example.com/runs/0461
REQ-015Saved searches can be shared with a team2026-R4SearchDiego AlvarezVerifiedhttps://qa.example.com/runs/0442
REQ-016Admins can review active sessions2027-R1AdminChen WeiDraft(blank)
REQ-017Users can change the display language2026-R3InterfaceMaya PatelVerifiedhttps://qa.example.com/runs/0448
REQ-018Credit notes reference the original invoice2026-R4BillingInes DuarteVerifiedhttps://qa.example.com/runs/0451
REQ-019Mobile push notifications can be muted per project2026-R4NotificationsDiego AlvarezImplemented(blank)
REQ-020Inactive accounts are flagged after 90 days2027-R1AccountsChen WeiDraft(blank)
REQ-021Admins can schedule maintenance banners2026-R3AdminMaya PatelVerifiedhttps://qa.example.com/runs/0460
REQ-022Search supports quoted phrases2026-R4SearchInes DuarteImplemented(blank)
REQ-023Error messages explain the next step2026-R4InterfaceDiego AlvarezVerifiedhttps://qa.example.com/runs/0466
REQ-024Billing contacts can be different from account owners2027-R1BillingChen WeiDraft(blank)
REQ-025Users can pause email digests2026-R3NotificationsMaya PatelVerifiedhttps://qa.example.com/runs/0472
REQ-026Admins can bulk deactivate users2026-R4AdminInes DuarteVerifiedhttps://qa.example.com/runs/0475
REQ-027Search results can be filtered by date2026-R4SearchDiego AlvarezImplemented(blank)
REQ-028Session timeout warns before sign-out2027-R1AccountsChen WeiDraft(blank)
  1. Edit a Confluence page and insert the Flint Table Filter macro.
  2. 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.
  3. Publish the page. Search, Filters, Sort, Columns, Summary, Export, Expand table and Reset view appear above the published table.

Step 1: Show one release

  1. Choose Filters, then Release. With few distinct values the column offers Is one of with a dropdown.
  2. In Matching values, choose 2026-R4. The value list shows 7 rows for 2026-R3, 14 for 2026-R4 and 7 for 2027-R1.
  3. 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.

  1. Choose Advanced groups, then Add group. Create the rule Status, Text, Does not equal, Verified, and choose Save rule.
  2. Set Match rules in group 1 to Any rule (OR).
  3. 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.

Expected result: 7 of 28 rows in release 2026-R4
Req IDRequirementComponentOwnerStatusEvidence
REQ-002Admins can export the audit log as CSVAdminInes DuarteImplemented(blank)
REQ-007Admins can require two-step verificationAccountsDiego AlvarezImplemented(blank)
REQ-010Users can download their dataAccountsInes DuarteVerified(blank)
REQ-014Notification emails include an unsubscribe linkNotificationsInes DuarteImplementedhttps://qa.example.com/runs/0461
REQ-019Mobile push notifications can be muted per projectNotificationsDiego AlvarezImplemented(blank)
REQ-022Search supports quoted phrasesSearchInes DuarteImplemented(blank)
REQ-027Search results can be filtered by dateSearchDiego AlvarezImplemented(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

  1. Choose Columns and clear Release; every visible row has the same value. The column still filters while hidden.
  2. Sort by Owner so each person can find their rows.
  3. Open Saved views and presentation, enter 2026-R4 evidence gaps in 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