BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · USE CASE

Run a weekly project status review in Confluence

Every status meeting starts with two questions: what is stuck, and what is due this week? Answer both from the tracker your team already keeps, then publish that view so the page opens on it every week.

What you will end with: from a 24-task tracker, the 12 tasks that are blocked or due this week, sorted by due date, with estimate totals by team. Published as the page’s starting view, the “this week” rule moves forward on its own each Monday.

Before you start

You need Flint Table Filter installed with an active subscription or trial, and permission to edit the page for the last step. Readers only need to view the page.

Sample tracker: project-tracker.csv · 24 rows, 7 columns, fictional data.

First 5 rows
Task IDTaskTeamOwnerStatusDueEstimate
PRJ-101Checkout API timeout fixEngineeringPriya ShahBlocked2026-11-063
PRJ-102Billing page redesignDesignMateo RuizIn progress2026-11-125
PRJ-103Release notes draftDocsHana SatoTo do2026-11-132
PRJ-104Search index migrationEngineeringLiam O'NeillIn progress2026-11-108
PRJ-105Help center screenshotsDocsHana SatoDone2026-11-041
Show all 24 rows
Task IDTaskTeamOwnerStatusDueEstimate
PRJ-101Checkout API timeout fixEngineeringPriya ShahBlocked2026-11-063
PRJ-102Billing page redesignDesignMateo RuizIn progress2026-11-125
PRJ-103Release notes draftDocsHana SatoTo do2026-11-132
PRJ-104Search index migrationEngineeringLiam O'NeillIn progress2026-11-108
PRJ-105Help center screenshotsDocsHana SatoDone2026-11-041
PRJ-106Support macro updateSupportAma MensahIn review2026-11-111
PRJ-107Launch email copyMarketingJonas BergIn progress2026-11-202
PRJ-108Accessibility fixesDesignMateo RuizBlocked2026-11-184
PRJ-109Rate limit alertsEngineeringPriya ShahTo do2026-11-143
PRJ-110Escalation runbookSupportAma MensahIn progress2026-11-272
PRJ-111Pricing FAQDocsLena FischerIn review2026-11-091
PRJ-112Webhook retry policyEngineeringLiam O'NeillBlocked2026-11-245
PRJ-113Customer webinar planMarketingJonas BergTo do2026-12-023
PRJ-114Status page wordingSupportAma MensahDone2026-11-051
PRJ-115Mobile layout reviewDesignNoor HaddadTo do2026-11-152
PRJ-116Data export test planEngineeringPriya ShahIn review2026-11-122
PRJ-117Partner briefing deckMarketingJonas BergBlocked2026-11-132
PRJ-118API changelogDocsLena FischerTo do2026-11-191
PRJ-119Trial onboarding emailsMarketingSofia CostaIn progress2026-11-163
PRJ-120Dependency upgradesEngineeringLiam O'NeillTo do2026-11-235
PRJ-121Ticket tag cleanupSupportTomás SilvaTo do2026-11-171
PRJ-122Icon refreshDesignNoor HaddadDone2026-11-022
PRJ-123Backup restore drillEngineeringPriya ShahTo do2026-11-303
PRJ-124Glossary updateDocsHana SatoIn progress2026-11-261
  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 project-tracker.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.

Why a column filter is not enough

Filters on different columns must all match. If you choose Status Is one of Blocked and then add a Due condition of This week, the table shows only tasks that are blocked and due this week. In the sample that is one task, PRJ-117. The meeting needs blocked tasks or tasks due this week, so the two rules belong in one advanced group set to match any rule.

Step 1: Find blocked work or work due this week

  1. Choose Filters, then Advanced groups.
  2. Choose Add group. In the new rule, set Rule column to Status, Rule type to Text, Rule condition to Equals and Rule value to Blocked. Choose Save rule.
  3. Set Match rules in group 1 to Any rule (OR).
  4. Choose Add rule to group 1. Set Rule column to Due, keep Rule type as Date, set Rule condition to Relative date and Rule date preset to This week. Choose Save rule, then Done.

The filter tag reads Advanced: 1 group, 2 rules and the count line reads 12 of 24 rows. Weeks run Monday through Sunday, so on 9 November the preset covers 9 to 15 November. Four tasks are blocked and nine are due this week; PRJ-117 is both.

Equals ignores case, so blocked works too. If your Status column uses Confluence status labels, the rule compares the label’s text.

Step 2: Sort by due date

Choose Sort in the Due column header, or open Sort, set Sort by to Due and Order to Ascending. Overdue blocked work rises to the top.

Expected result: 12 of 24 rows, Due ascending
Task IDTaskTeamOwnerStatusDueEstimate
PRJ-101Checkout API timeout fixEngineeringPriya ShahBlocked2026-11-063
PRJ-111Pricing FAQDocsLena FischerIn review2026-11-091
PRJ-104Search index migrationEngineeringLiam O'NeillIn progress2026-11-108
PRJ-106Support macro updateSupportAma MensahIn review2026-11-111
PRJ-102Billing page redesignDesignMateo RuizIn progress2026-11-125
PRJ-116Data export test planEngineeringPriya ShahIn review2026-11-122
PRJ-103Release notes draftDocsHana SatoTo do2026-11-132
PRJ-117Partner briefing deckMarketingJonas BergBlocked2026-11-132
PRJ-109Rate limit alertsEngineeringPriya ShahTo do2026-11-143
PRJ-115Mobile layout reviewDesignNoor HaddadTo do2026-11-152
PRJ-108Accessibility fixesDesignMateo RuizBlocked2026-11-184
PRJ-112Webhook retry policyEngineeringLiam O'NeillBlocked2026-11-245

PRJ-102 and PRJ-116 share a due date and keep their table order. Choose Add sort column and add a Then by column, such as Team, if ties should follow a rule.

Step 3: See which team carries the load

  1. Choose Summary. Set Summarize column to Estimate.
  2. Set Group rows by to Team and Group order to Most rows first.

The summary covers all 12 matching rows, including any on later pages: a sum of 38 estimate days. The grouped summary reports 5 groups:

Grouped summary for the 12 matching tasks
GroupRowsSum of Estimate
Engineering521
Design311
Docs23
Marketing12
Support11

Choose Show rows: “Engineering” to limit the table to Engineering’s five tasks while you discuss them. The group totals still cover every matching row. Choose Clear group focus when you move on. Grouping and totals explains ranking, focus and subtotal headings in more detail.

Step 4: Make it the page’s starting view

Your filters, sort and summary so far are yours alone and reset when the page reloads. To open the page on this view for every reader, copy the advanced rule into the macro settings and add the matching defaults.

  1. In Advanced groups, choose Copy advanced filter settings. Select everything in Advanced filter settings and copy it. Choose Back to advanced groups.
  2. Edit the page and open the Flint Table Filter macro settings.
  3. Set Settings section to Column filters and advanced rules and paste into Default advanced filter groups.
  4. Fill in the remaining sections as shown below. Starting view preview reports 12 of 24 rows match and previews the first five rows.
  5. Choose Save settings, then publish the page.

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

Default advanced filter groups
The copied settings
Default sort column
Due
Default sort direction
Ascending
Default summary column
Estimate
Default group column
Team
Default group order
Most rows first

The copied settings refer to column headers by name and store the preset, not the dates, which is why the view rolls forward each week:

{
  "version": 1,
  "match": "all",
  "groups": [
    {
      "match": "any",
      "rules": [
        {
          "header": "Status",
          "condition": {
            "type": "text",
            "dateFormat": "iso",
            "operator": "equals",
            "value": "Blocked",
            "valueTo": "",
            "preset": ""
          }
        },
        {
          "header": "Due",
          "condition": {
            "type": "date",
            "dateFormat": "iso",
            "operator": "relative",
            "value": "",
            "valueTo": "",
            "preset": "thisWeek"
          }
        }
      ]
    }
  ]
}

After publishing, readers see Author defaults currently applied: Due ascending; advanced filters; summary: Estimate; group by: Team; group order: Most rows first. Anyone can narrow further during the meeting, for example to one team, and Reset view returns them to this starting view.

Run the meeting

What to know