Capabilities Grids

Any table size, one grid: scroll, sort, filter, edit, export.

The grid renders the rows in view and fetches the next window as you scroll; sorting, filtering and aggregation are pushed down to the source or the bed.

Request a demo See it with cell rules

A window of rows rendered; the engine does the sorting, filtering and aggregation; exports run under the same security.

48.2M

rows in the showcase material table, scrolled from one grid

showcase

rows rendered at a time; the rest fetched as you scroll

product

1,284

concurrent users at a 3.1 s p99 on the showcase estate

showcase

row limit on governed exports

product

Step by step

What the grid does when you scroll, sort and edit

OpenThe grid asks the engine for the first window with the default sort; the engine pushes the sort and any filter down and returns 60 rows and the total count.

ScrollThe next window is fetched with a stable key, so rows stay put; scrolling to row 30 million is one request.

Filter and groupA filter on a column or a group-by runs in the engine; the grid shows the groups with their counts and lets you expand one.

EditA cell validates as you type against its column rules; a row saves with its row rules; a business rule that the change touches runs on save; survivorship applies.

Fill and pasteFill down, paste a range from a spreadsheet, or apply a value to a filtered set; every cell still validates, every row still logs.

ExportA governed extract of any size runs as your identity: masks and row filters apply, and the export is logged with its filter.

What you see

The material grid on the showcase estate

golden.material · 48,213,907 rows · sorted by stock valuefilters: plant 1210 · activegroup by: nonewindow 4 of 803,565

material	description	plant	stock	value	lead time	rule
M-1183920	resistor 470 Ω 1% 0603	1210	128,400	€2,337	21 d	pass
M-2200417	housing, cast, 220 mm	1210	3,180	€412,300	42 d	lead time drift
M-0091114	bearing 6204-2RS	2000	18,900	€27,405	14 d	pass
M-3391005	controller board rev C	1210	412	€184,210	70 d	over 12 weeks safety

Columns come from the golden view and from the transactions in the same bed: description and lead time are master data, stock and value are live facts. The rule column shows the latest rule results per row, and a click opens the rule's evidence.

Why it stays fast

The engine does the work

The grid holds only a window of the table. Every sort, filter, group and aggregate is a query the engine pushes to the source or runs on the bed, and only the rows in view travel. Keys stay stable across windows, so an edit on row 3 million lands on the right row after a re-sort.

The same component renders a steward's cluster of fourteen records, a drill-down from a pivot cell into 214,000 order lines, and a governed extract of the whole table; each is one query with the same security.

Window60 rows rendered; the next fetched at 40

Pushdownsort · filter · group · aggregate

Keysstable across windows and re-sorts

Editingcell validation · row save · rule run · survivorship

Exportany size · your identity · logged

How master-data hubs usually do it

What is standard, and what is different here

Hub interfaces page results and cap exports; inline and bulk editing are common; spreadsheet-style editing appears in some products. Virtual scrolling with pushdown is rarer, and where it exists it covers the hub's own tables, because the transactions sit elsewhere.

Here the grid scrolls the federated result set, so a transaction table of tens of millions of rows and a master table of thousands look and behave the same, and an export has no fixed row cap.

Standard everywherepaged results; inline edit; bulk update; capped exports

Herevirtual scrolling over federated results; governed exports of any size

Consequenceone grid for master data, transactions, clusters and drill-downs

Terms on this page

Virtual scrollingRendering only the rows in view and fetching the next window as you scroll.

PushdownSending sorts, filters and aggregates to the source or the bed so only the needed rows travel.

Governed extractAn export run as the person's identity, with masks and row filters applied and the export logged.

Questions

Can I edit transactions in the grid?

Where the domain allows it and the owning system accepts a write-back: a planner edits a forecast row; an order line stays read-only unless the process app owns the change.

How does the grid handle a slow source?

The window request carries a time budget; a source over budget answers from its cached or replicated contract, and the column says so.

Is there a spreadsheet add-in?

The workbench exposes the same grid through SQL to spreadsheets; a native add-in is on the roadmap (see the review notes).

See your first domain built on your data

Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.

Request a demo How the first day runs