BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · USE CASE

Review risks, issues and overdue actions in a Confluence register

A register only helps if the items that need attention rise to the top. Combine status, severity, due dates and ownership in one view, ranked by the score your team already maintains.

What you will end with: from 20 register entries, 16 that are not closed, and of those the 11 that are critical or high, overdue, or without an owner, ranked by Score and then by due date.

Before you start

The register below keeps a numeric Score that your team already calculates, for example likelihood multiplied by impact. Flint Table Filter reads and ranks that score; it does not calculate it, so keep the source value current.

Sample register: risk-register.csv · 20 rows, 8 columns, fictional data.

First 5 rows
RefTypeDescriptionOwnerSeverityStatusDueScore
R-01RiskPayment provider contract lapses before renewalDana KimHighOpen2026-11-2016
R-02IssueNightly backup job failed twiceOmar HaddadCriticalOpen2026-11-0520
R-03ActionUpdate supplier contact listGrace LiuLowClosed2026-10-304
R-04RiskKey engineer on extended leave in December(blank)MediumOpen2026-12-0112
R-05IssueCustomer export emails delayedOmar HaddadHighMonitoring2026-11-1215
Show all 20 rows
RefTypeDescriptionOwnerSeverityStatusDueScore
R-01RiskPayment provider contract lapses before renewalDana KimHighOpen2026-11-2016
R-02IssueNightly backup job failed twiceOmar HaddadCriticalOpen2026-11-0520
R-03ActionUpdate supplier contact listGrace LiuLowClosed2026-10-304
R-04RiskKey engineer on extended leave in December(blank)MediumOpen2026-12-0112
R-05IssueCustomer export emails delayedOmar HaddadHighMonitoring2026-11-1215
R-06ActionRotate shared service account passwordDana KimHighOpen2026-11-0315
R-07RiskData center migration overlaps peak seasonFelix WagnerCriticalOpen2026-12-1525
R-08IssueDuplicate invoices for three customersGrace LiuMediumClosed2026-10-289
R-09ActionReview vendor security questionnaire(blank)MediumOpen2026-11-068
R-10RiskOffice lease decision delayedFelix WagnerLowMonitoring2027-01-156
R-11IssueMobile app crash on older devicesOmar HaddadHighOpen2026-11-1816
R-12ActionPublish incident reviewDana KimMediumOpen2026-10-3110
R-13RiskSingle supplier for replacement laptopsGrace LiuMediumMonitoring2026-12-1012
R-14IssueSupport queue above target for two weeks(blank)HighOpen2026-11-1316
R-15ActionTest disaster recovery runbookFelix WagnerHighClosed2026-10-2015
R-16RiskNew privacy regulation affects sign-up flowDana KimMediumOpen2027-02-019
R-17ActionConfirm holiday on-call coverageOmar HaddadLowOpen2026-11-254
R-18IssueSearch results stale after reindexFelix WagnerMediumOpen2026-11-0212
R-19RiskBudget approval for monitoring toolsGrace LiuLowOpen2026-12-206
R-20ActionArchive retired project spaces(blank)LowClosed2026-10-152
  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 risk-register.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.

The worked examples use Monday 9 November 2026 as today. Relative date presets follow each reader’s device calendar, so on another day the same rule matches different rows. Where it matters, a fixed date range that reproduces the published result is included.

Step 1: Leave out closed entries

  1. Choose Filters. Set Column to Status and Condition to Is not one of.
  2. In Excluded values, choose Closed. The number beside each value counts the rows that contain it, given search and the other filters.
  3. Choose Done.

The count line reads 16 of 20 rows. Excluding Closed, rather than including Open and Monitoring, keeps any new status your team adds later in the review.

Step 2: Keep only what needs attention

An entry needs attention if any of four things is true, so these rules go in one advanced group that matches any rule. Column filters and advanced groups must both match, so closed entries stay out.

  1. Choose Advanced groups, then Add group. Create the rule Severity, Text, Equals, Critical, and choose Save rule.
  2. Set Match rules in group 1 to Any rule (OR).
  3. Use Add rule to group 1 three more times:
    • Severity, Text, Equals, High
    • Due, Date, Before, 2026-11-09
    • Owner, Text, Is empty
  4. Choose Done.

The filter button reads Filters (5): one column filter and four advanced rules. The count line reads 11 of 20 rows.

Step 3: Rank by score

Open Sort, set Sort by to Score with Order Descending, then choose Add sort column and set Then by (2) to Due, Ascending. Entries with the same score appear in due-date order.

Expected result: 11 of 20 rows, Score descending then Due ascending
RefTypeOwnerSeverityStatusDueScore
R-07RiskFelix WagnerCriticalOpen2026-12-1525
R-02IssueOmar HaddadCriticalOpen2026-11-0520
R-14Issue(blank)HighOpen2026-11-1316
R-11IssueOmar HaddadHighOpen2026-11-1816
R-01RiskDana KimHighOpen2026-11-2016
R-06ActionDana KimHighOpen2026-11-0315
R-05IssueOmar HaddadHighMonitoring2026-11-1215
R-18IssueFelix WagnerMediumOpen2026-11-0212
R-04Risk(blank)MediumOpen2026-12-0112
R-12ActionDana KimMediumOpen2026-10-3110
R-09Action(blank)MediumOpen2026-11-068

R-18 and R-12 are Medium severity but appear because they are overdue. R-04 appears because nobody owns it, and R-09 is both unowned and overdue.

Answer narrower questions quickly

Keep the Status exclusion and replace the advanced group with a single column condition when the meeting asks one question at a time:

Each result applies to the 16 entries that are not closed
QuestionColumn conditionMatching entries
What is overdue?Due, Before, 2026-11-09R-02, R-06, R-09, R-12, R-18
What has no owner?Owner, Is emptyR-04, R-09, R-14
What scores 15 or more?Score, At least, 15R-07, R-02, R-01, R-11, R-14, R-05, R-06

Remove a single condition with its tag above the table, or use Reset view to clear everything.

Keep overdue rolling

Before uses the date you type, so it does not move. For a starting view that stays current, use a relative date instead: set Due to Relative date, choose Last N days and enter 365. That matches due dates from the past year up to and including today, so an item due today counts as needing attention.

Compare entry types

With only the Status exclusion active, open Summary, set Summarize column to Score, Group rows by to Type and Group order to Highest average first. The 16 open entries split into Issues (5 rows, average 15.8), Risks (7 rows, average about 12.3) and Actions (4 rows, average 9.25).

What to know