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.
| Ref | Type | Description | Owner | Severity | Status | Due | Score |
|---|---|---|---|---|---|---|---|
| R-01 | Risk | Payment provider contract lapses before renewal | Dana Kim | High | Open | 2026-11-20 | 16 |
| R-02 | Issue | Nightly backup job failed twice | Omar Haddad | Critical | Open | 2026-11-05 | 20 |
| R-03 | Action | Update supplier contact list | Grace Liu | Low | Closed | 2026-10-30 | 4 |
| R-04 | Risk | Key engineer on extended leave in December | (blank) | Medium | Open | 2026-12-01 | 12 |
| R-05 | Issue | Customer export emails delayed | Omar Haddad | High | Monitoring | 2026-11-12 | 15 |
Show all 20 rows
| Ref | Type | Description | Owner | Severity | Status | Due | Score |
|---|---|---|---|---|---|---|---|
| R-01 | Risk | Payment provider contract lapses before renewal | Dana Kim | High | Open | 2026-11-20 | 16 |
| R-02 | Issue | Nightly backup job failed twice | Omar Haddad | Critical | Open | 2026-11-05 | 20 |
| R-03 | Action | Update supplier contact list | Grace Liu | Low | Closed | 2026-10-30 | 4 |
| R-04 | Risk | Key engineer on extended leave in December | (blank) | Medium | Open | 2026-12-01 | 12 |
| R-05 | Issue | Customer export emails delayed | Omar Haddad | High | Monitoring | 2026-11-12 | 15 |
| R-06 | Action | Rotate shared service account password | Dana Kim | High | Open | 2026-11-03 | 15 |
| R-07 | Risk | Data center migration overlaps peak season | Felix Wagner | Critical | Open | 2026-12-15 | 25 |
| R-08 | Issue | Duplicate invoices for three customers | Grace Liu | Medium | Closed | 2026-10-28 | 9 |
| R-09 | Action | Review vendor security questionnaire | (blank) | Medium | Open | 2026-11-06 | 8 |
| R-10 | Risk | Office lease decision delayed | Felix Wagner | Low | Monitoring | 2027-01-15 | 6 |
| R-11 | Issue | Mobile app crash on older devices | Omar Haddad | High | Open | 2026-11-18 | 16 |
| R-12 | Action | Publish incident review | Dana Kim | Medium | Open | 2026-10-31 | 10 |
| R-13 | Risk | Single supplier for replacement laptops | Grace Liu | Medium | Monitoring | 2026-12-10 | 12 |
| R-14 | Issue | Support queue above target for two weeks | (blank) | High | Open | 2026-11-13 | 16 |
| R-15 | Action | Test disaster recovery runbook | Felix Wagner | High | Closed | 2026-10-20 | 15 |
| R-16 | Risk | New privacy regulation affects sign-up flow | Dana Kim | Medium | Open | 2027-02-01 | 9 |
| R-17 | Action | Confirm holiday on-call coverage | Omar Haddad | Low | Open | 2026-11-25 | 4 |
| R-18 | Issue | Search results stale after reindex | Felix Wagner | Medium | Open | 2026-11-02 | 12 |
| R-19 | Risk | Budget approval for monitoring tools | Grace Liu | Low | Open | 2026-12-20 | 6 |
| R-20 | Action | Archive retired project spaces | (blank) | Low | Closed | 2026-10-15 | 2 |
- 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 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.
- 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
- Choose Filters. Set Column to Status and Condition to Is not one of.
- In Excluded values, choose Closed. The number beside each value counts the rows that contain it, given search and the other filters.
- 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.
- Choose Advanced groups, then Add group. Create the rule Severity, Text, Equals,
Critical, and choose Save rule. - Set Match rules in group 1 to Any rule (OR).
- Use Add rule to group 1 three more times:
- Severity, Text, Equals,
High - Due, Date, Before,
2026-11-09 - Owner, Text, Is empty
- Severity, Text, Equals,
- 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.
| Ref | Type | Owner | Severity | Status | Due | Score |
|---|---|---|---|---|---|---|
| R-07 | Risk | Felix Wagner | Critical | Open | 2026-12-15 | 25 |
| R-02 | Issue | Omar Haddad | Critical | Open | 2026-11-05 | 20 |
| R-14 | Issue | (blank) | High | Open | 2026-11-13 | 16 |
| R-11 | Issue | Omar Haddad | High | Open | 2026-11-18 | 16 |
| R-01 | Risk | Dana Kim | High | Open | 2026-11-20 | 16 |
| R-06 | Action | Dana Kim | High | Open | 2026-11-03 | 15 |
| R-05 | Issue | Omar Haddad | High | Monitoring | 2026-11-12 | 15 |
| R-18 | Issue | Felix Wagner | Medium | Open | 2026-11-02 | 12 |
| R-04 | Risk | (blank) | Medium | Open | 2026-12-01 | 12 |
| R-12 | Action | Dana Kim | Medium | Open | 2026-10-31 | 10 |
| R-09 | Action | (blank) | Medium | Open | 2026-11-06 | 8 |
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:
| Question | Column condition | Matching entries |
|---|---|---|
| What is overdue? | Due, Before, 2026-11-09 | R-02, R-06, R-09, R-12, R-18 |
| What has no owner? | Owner, Is empty | R-04, R-09, R-14 |
| What scores 15 or more? | Score, At least, 15 | R-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
- Blank or non-numeric scores are excluded from numeric conditions and summaries. When sorting, numbers come first, then text, and blank cells stay at the bottom.
- Filtering changes what you see, not who can see it. The complete register stays in the page and in Confluence PDF and Word exports.
- The app does not send reminders or change statuses. Record decisions in the source table and publish the page.
- To publish this view for every reader, copy the advanced group as described in the AND/OR guide and add Status to Default filter column with the condition Text: does not equal (ignores case) and the value Closed.