BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · USE CASE

Make an equipment inventory easier to search and review

Inventories grow into long tables. Find one device in seconds, spot equipment nobody is assigned to, list warranties ending soon, and hand the list on without losing the zeros at the start of each asset ID.

What you will end with: asset 004205 found by search, 12 devices without an assignee (including one marked In use), and the 15 non-retired devices whose warranty ends between 1 November 2026 and 31 March 2027, exported with IDs such as 004142 intact.

Before you start

Asset IDs such as 004205 look like numbers, so Flint Table Filter detects the Asset ID column as a number column. That matters for exact matching and for exports, as shown below.

Sample inventory: equipment-inventory.csv · 48 rows, 6 columns, fictional data. If a spreadsheet app opens this file, import Asset ID as text so its leading zeros survive.

First 5 rows
Asset IDDeviceLocationAssigned toStatusWarranty end
004100Laptop 14-inchAustin officeAvery BrooksIn use2026-09-15
004107Monitor 27-inchBerlin officeElif DemirIn use2026-09-24
004114USB-C dockStorage room B(blank)In stock2026-10-03
004121Desk phoneRemoteOskar LindIn use2026-10-12
004128Tablet 11-inchAustin officeDiego AlvarezIn use2026-10-21
Show all 48 rows
Asset IDDeviceLocationAssigned toStatusWarranty end
004100Laptop 14-inchAustin officeAvery BrooksIn use2026-09-15
004107Monitor 27-inchBerlin officeElif DemirIn use2026-09-24
004114USB-C dockStorage room B(blank)In stock2026-10-03
004121Desk phoneRemoteOskar LindIn use2026-10-12
004128Tablet 11-inchAustin officeDiego AlvarezIn use2026-10-21
004135HeadsetBerlin officeGabriel MoreauRepair2026-10-30
004142Laptop 14-inchRemoteMaya PatelIn use2026-11-08
004149Monitor 27-inchRemoteChen WeiIn use2026-11-17
004156USB-C dockStorage room B(blank)In stock2026-11-26
004163Desk phoneStorage room B(blank)Retired2026-12-05
004170Tablet 11-inchRemoteAvery BrooksIn use2026-12-14
004177HeadsetRemoteElif DemirIn use2026-12-23
004184Laptop 14-inchAustin officeInes DuarteIn use2027-01-01
004191Monitor 27-inchBerlin officeOskar LindIn use2027-01-10
004198USB-C dockStorage room B(blank)In stock2027-01-19
004205Desk phoneRemoteGabriel MoreauIn use2027-01-28
004212Tablet 11-inchAustin officeMaya PatelRepair2027-02-06
004219HeadsetBerlin officeChen WeiIn use2027-02-15
004226Laptop 14-inchRemoteFatima NoorIn use2027-02-24
004233Monitor 27-inchRemoteKofi AsanteIn use2027-03-05
004240USB-C dockStorage room B(blank)In stock2027-03-14
004247Desk phoneBerlin officeElif DemirIn use2027-03-23
004254Tablet 11-inchStorage room B(blank)Retired2027-04-01
004261HeadsetRemoteOskar LindIn use2027-04-10
004268Laptop 14-inchAustin officeDiego AlvarezIn use2027-04-19
004275Monitor 27-inchBerlin officeGabriel MoreauIn use2027-04-28
004282USB-C dockStorage room B(blank)In stock2027-05-07
004289Desk phoneStorage room BChen WeiRepair2027-05-16
004296Tablet 11-inchAustin officeFatima NoorIn use2027-05-25
004303HeadsetBerlin officeKofi AsanteIn use2027-06-03
004310Laptop 14-inchRemoteAvery BrooksIn use2027-06-12
004317Monitor 27-inchRemoteElif DemirIn use2027-06-21
004324USB-C dockStorage room B(blank)In stock2027-06-30
004331Desk phoneBerlin officeOskar LindIn use2027-07-09
004338Tablet 11-inchRemoteDiego AlvarezIn use2027-07-18
004345HeadsetStorage room B(blank)Retired2027-07-27
004352Laptop 14-inchAustin officeMaya PatelIn use2027-08-05
004359Monitor 27-inchBerlin officeChen WeiIn use2027-08-14
004366USB-C dockStorage room B(blank)In stock2027-08-23
004373Desk phoneRemoteKofi AsanteIn use2027-09-01
004380Tablet 11-inchAustin officeAvery BrooksIn use2027-09-10
004387HeadsetBerlin office(blank)In use2027-09-19
004394Laptop 14-inchRemoteInes DuarteIn use2027-09-28
004401Monitor 27-inchRemoteOskar LindIn use2027-10-07
004408USB-C dockStorage room B(blank)In stock2027-10-16
004415Desk phoneBerlin officeGabriel MoreauIn use2027-10-25
004422Tablet 11-inchRemoteMaya PatelIn use2027-11-03
004429HeadsetRemoteChen WeiIn use2027-11-12
  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 equipment-inventory.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.

Find one device

Type 004205 in Search table. Search looks for the text anywhere in any column, ignoring case, so the table shows one row: a desk phone assigned to Gabriel Moreau. Partial text works too: 4205 finds the same device.

For an exact match, open Filters and choose Asset ID. Because the column is detected as a number, Equals 4205 also matches 004205: both are the number 4205. If your IDs must match character for character, set Treat column as to Text and enter 004205; with Text, 4205 matches nothing.

This inventory has 48 distinct IDs, so Is one of offers a dropdown. Once a column has more than 50 distinct values, it switches to a searchable list of ten values per page with Find a value.

Find unassigned equipment

  1. Choose Reset view, then Filters.
  2. Set Column to Assigned to and Condition to Is empty.

Twelve devices have no assignee. To see why, open Summary and set Group rows by to Status: 8 are In stock, 3 are Retired and 1 is In use. Choose Show rows: “In use” to find the record that needs fixing.

Expected result: 12 of 48 rows with Assigned to empty
Asset IDDeviceLocationStatus
004114USB-C dockStorage room BIn stock
004156USB-C dockStorage room BIn stock
004163Desk phoneStorage room BRetired
004198USB-C dockStorage room BIn stock
004240USB-C dockStorage room BIn stock
004254Tablet 11-inchStorage room BRetired
004282USB-C dockStorage room BIn stock
004324USB-C dockStorage room BIn stock
004345HeadsetStorage room BRetired
004366USB-C dockStorage room BIn stock
004387HeadsetBerlin officeIn use
004408USB-C dockStorage room BIn stock

Asset 004387 is a headset in the Berlin office marked In use with no assignee: either the status or the assignment is out of date.

Review warranties ending this winter

  1. Choose Reset view, then Filters.
  2. Choose Warranty end, set Condition to Between, and enter 2026-11-01 in From (inclusive) and 2027-03-31 in To (inclusive).
  3. Choose Status, set Condition to Is not one of and exclude Retired.
  4. In the Warranty end header, choose Sort once for ascending order.
Expected result: 15 of 48 rows, Warranty end ascending
Asset IDDeviceAssigned toStatusWarranty end
004142Laptop 14-inchMaya PatelIn use2026-11-08
004149Monitor 27-inchChen WeiIn use2026-11-17
004156USB-C dock(blank)In stock2026-11-26
004170Tablet 11-inchAvery BrooksIn use2026-12-14
004177HeadsetElif DemirIn use2026-12-23
004184Laptop 14-inchInes DuarteIn use2027-01-01
004191Monitor 27-inchOskar LindIn use2027-01-10
004198USB-C dock(blank)In stock2027-01-19
004205Desk phoneGabriel MoreauIn use2027-01-28
004212Tablet 11-inchMaya PatelRepair2027-02-06
004219HeadsetChen WeiIn use2027-02-15
004226Laptop 14-inchFatima NoorIn use2027-02-24
004233Monitor 27-inchKofi AsanteIn use2027-03-05
004240USB-C dock(blank)In stock2027-03-14
004247Desk phoneElif DemirIn use2027-03-23

The first device’s warranty ended on 8 November, the day before the example’s today. For a rolling list, use Relative date with Next N days instead of fixed dates.

Export the list with IDs intact

  1. Choose Columns and clear Location. The button reads Columns (5/6).
  2. Choose Export. Keep Export scope as Current result.
  3. Choose Download XLSX for a spreadsheet, or Download CSV for another system.

These sample files were produced from the fictional table by the export logic of Flint Table Filter 2.5.0, running outside Confluence. They show the released file format; they are not downloads from a customer site.

"Asset ID","Device","Assigned to","Status","Warranty end"
"004142","Laptop 14-inch","Maya Patel","In use","2026-11-08"
"004149","Monitor 27-inch","Chen Wei","In use","2026-11-17"
"004156","USB-C dock","","In stock","2026-11-26"

Both files contain 004142 exactly. The difference appears when a spreadsheet app opens them: a CSV has no column types, so an app can convert 004142 to the number 4142 unless you import that column as text. The XLSX stores every value as text, so the leading zeros stay.

What to know