BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · USE CASE

Build a content review queue from a Confluence table

Knowledge bases stay trustworthy when someone reviews each page on schedule. Keep the schedule in a table and work it as a queue: what is due this month, what is late, and what has nobody to review it.

What you will end with: from 24 tracked documents, the 14 unapproved reviews due in November 2026, the 6 that were already late on 9 November, and the 4 documents without an owner, plus a starting view that shows the current month to every reader.

What this queue does and does not do

Editors maintain the table: one row per document, with its owner, team, last review and next review date. Flint Table Filter turns that table into queues. It does not find stale pages, read page history, change review dates or send reminders.

Sample review schedule: content-review-queue.csv · 24 rows, 7 columns, fictional data.

First 5 rows
DocumentSpaceOwnerTeamLast reviewedReview dueReview status
Expense policyFinanceGrace LiuFinance2026-05-122026-11-12Not started
Laptop setup checklistITKofi AsanteIT2026-08-032026-11-03In review
Incident response runbookEngineeringPriya ShahEngineering2026-05-202026-11-20Not started
Customer refund stepsSupport(blank)Support2026-04-282026-10-28Not started
Brand voice guideMarketingJonas BergMarketing2026-06-012026-12-01Not started
Show all 24 rows
DocumentSpaceOwnerTeamLast reviewedReview dueReview status
Expense policyFinanceGrace LiuFinance2026-05-122026-11-12Not started
Laptop setup checklistITKofi AsanteIT2026-08-032026-11-03In review
Incident response runbookEngineeringPriya ShahEngineering2026-05-202026-11-20Not started
Customer refund stepsSupport(blank)Support2026-04-282026-10-28Not started
Brand voice guideMarketingJonas BergMarketing2026-06-012026-12-01Not started
On-call handbookEngineeringLiam O'NeillEngineering2026-08-142026-11-14In review
Travel booking guideOperationsMaya PatelOperations2026-05-022026-11-02Approved
Security awareness basicsIT(blank)IT2026-05-302026-11-30Not started
Release checklistEngineeringPriya ShahEngineering2026-08-062026-11-06Not started
Escalation matrixSupportAma MensahSupport2026-05-192026-11-19In review
Press inquiry processMarketingSofia CostaMarketing2026-04-152026-10-15In review
Parental leave policyPeopleElif DemirPeople2026-06-102026-12-10Not started
VPN troubleshootingITKofi AsanteIT2026-08-092026-11-09Not started
Data retention scheduleLegalOskar LindLegal2026-05-252026-11-25Not started
Office access procedureOperations(blank)Operations2026-05-112026-11-11Not started
API style guideEngineeringLiam O'NeillEngineering2026-06-182026-12-18Not started
Support tone guidelinesSupportAma MensahSupport2026-04-302026-10-30Approved
Vendor onboarding stepsFinanceGrace LiuFinance2026-08-262026-11-26Not started
Accessibility checklistDesignNoor HaddadDesign2026-05-162026-11-16In review
New hire first weekPeopleElif DemirPeople2026-08-012026-11-01Approved
Backup restore guideIT(blank)IT2026-04-222026-10-22Not started
Pricing page rulesMarketingJonas BergMarketing2026-05-272026-11-27Not started
Code review checklistEngineeringPriya ShahEngineering2026-06-052026-12-05Not started
Contract approval flowLegalOskar LindLegal2026-05-082026-11-08In review
  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 content-review-queue.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.

Queue 1: Reviews due this month

  1. Choose Filters, then Review due. Set Condition to Relative date and Date preset to This month.
  2. Choose Review status, set Condition to Is not one of and exclude Approved.
  3. Sort Review due ascending.
Expected result: 14 of 24 rows due in November 2026
DocumentOwnerTeamReview dueReview status
Laptop setup checklistKofi AsanteIT2026-11-03In review
Release checklistPriya ShahEngineering2026-11-06Not started
Contract approval flowOskar LindLegal2026-11-08In review
VPN troubleshootingKofi AsanteIT2026-11-09Not started
Office access procedure(blank)Operations2026-11-11Not started
Expense policyGrace LiuFinance2026-11-12Not started
On-call handbookLiam O'NeillEngineering2026-11-14In review
Accessibility checklistNoor HaddadDesign2026-11-16In review
Escalation matrixAma MensahSupport2026-11-19In review
Incident response runbookPriya ShahEngineering2026-11-20Not started
Data retention scheduleOskar LindLegal2026-11-25Not started
Vendor onboarding stepsGrace LiuFinance2026-11-26Not started
Pricing page rulesJonas BergMarketing2026-11-27Not started
Security awareness basics(blank)IT2026-11-30Not started

To share out the work, open Summary, set Group rows by to Team and Group order to Most rows first: Engineering 3, IT 3, Finance 2, Legal 2, Design 1, Marketing 1, Operations 1, Support 1.

Queue 2: Overdue reviews

  1. Choose Reset view, then Filters.
  2. Choose Review due, set Condition to Before and enter today’s date, 2026-11-09.
  3. Exclude Approved in Review status, as before, and sort Review due ascending.
Expected result: 6 of 24 rows due before 9 November 2026
DocumentOwnerReview dueReview status
Press inquiry processSofia Costa2026-10-15In review
Backup restore guide(blank)2026-10-22Not started
Customer refund steps(blank)2026-10-28Not started
Laptop setup checklistKofi Asante2026-11-03In review
Release checklistPriya Shah2026-11-06Not started
Contract approval flowOskar Lind2026-11-08In review

Before keeps the date you typed. For a queue that stays current without editing, use Relative date, Last N days and 365: it matches review dates in the past year up to and including today. On 9 November it returns 7 documents, adding VPN troubleshooting, which is due that day.

Queue 3: Documents without an owner

Choose Reset view, then set Owner to Is empty. Four documents have nobody responsible, regardless of status:

Expected result: 4 of 24 rows with Owner empty
DocumentTeamReview dueReview status
Customer refund stepsSupport2026-10-28Not started
Security awareness basicsIT2026-11-30Not started
Office access procedureOperations2026-11-11Not started
Backup restore guideIT2026-10-22Not started

Publish the monthly queue

An author can make Queue 1 the page’s starting view. Starting view preview reports 14 of 24 rows match on 9 November, and the month advances with each reader’s calendar.

Macro settings, shortened to the start of each label. One value per line where shown on separate lines.

Default filter column
Review due
Default filter condition
Date: this month
Default filter 2 column
Review status
Default filter 2 condition
Text: does not equal (ignores case)
Default filter 2 value or lower bound
Approved
Default sort column
Review due
Default group column
Team
Default group order
Most rows first

Owners can then add their own name in a filter and save the result as a personal view called “My reviews”.

What to know