Table cards show rows: devices, alarms, sites, readings, events. They sort, search, page and download. This page covers the general Table card, the IoT Device table and Alarm table, and the Activity feed.
Table
Bind the Rows slot to a table source, for example Devices (live connection state), Alarms (live), Latest values of many devices (a row per device) or Status under an asset.
Columns
Columns picks, renames and orders the columns the query declares, up to 30. Empty shows all of them in the query’s order. Per column:
| Field | Values |
|---|---|
| Column, Header | The query’s column and your heading (default: as declared) |
| Show | Always, Not on phones, Only on phones, Hidden |
| Cell | Auto, Text, Number, Date, Badge, Bar, Progress, Link, Icon |
| Value colours | Up to 30 rows mapping a value (any case) to a colour, a label and an icon. Badges and icons use them. |
| Badge style | Tinted, Dot, Solid |
| Date shown as | As the table, relative (“5m ago”), date, time, date and time, or a custom pattern such as dd.MM.yyyy HH:mm |
| Link | An internal path; {column} is replaced by the row’s value, for example /admin/devices/{id} |
| Sortable, Align, Width, Long text | Sorting on; auto alignment; auto, narrow, wide or fixed (24 to 800 px); one line, cut with …, or wrap |
| Bar maximum, Colour ranges | The value of a full bar (default: the largest value for Bar, 100 for Progress) and the ranges that colour it |
Auto shows a badge for badge columns or when value colours are set, right-aligns numbers and formats dates.
Rows and viewer tools
| Setting | Values and defaults |
|---|---|
| Rows per page | 1 to 100 (10) |
| More rows | Cut off (default), Page buttons, Scroll all. A query that pages on the server always shows its own pager. |
| Sort by, Direction | A column, descending by default |
| Row numbers | Off |
| Only rows that changed | For history-like rows: a row equal to the one before it (dates ignored) is left out |
| Timestamp first, kept in view | The first date column leads and stays put while the table scrolls sideways |
| Search box | On. Filters the loaded rows; for a query that pages on the server, it searches on the server when the query supports it. |
| Viewers can sort, Viewers can hide columns | On, off |
| Row height | Compact (28), Normal (36), Roomy (44); lines between rows, grid or none |
A table that pages on the server never updates live: it refreshes on its interval.
Device table
The IoT Device table draws your devices with an online dot. Bind Rows to Devices (live connection state). Its source filters: Profile, Status (Active and disabled by default, Active, Disabled, Quarantined, Every status), Connection (Any, Online, Offline, Last seen only, Never connected), Rows (at most 500) (100) and Devices (an entity alias) to show only a parameter’s devices.
Optional: bind Values to Latest values of many devices to add telemetry columns, and set a stale threshold after which the online dot greys. A row click can open the device’s page or set a board parameter.
Alarm table
The IoT Alarm table draws alarms with severity chips (Critical, Major, Minor, Warning, Info) and status pills. Bind Rows to Alarms (live). Source settings: Status (Active (open and acknowledged) by default), Severity, Ignore the board window, Rows (at most 500) (100), Devices (an entity alias), Only this element’s alarms, Open alarms before resolved ones. Card settings: which severities show, severity chips the viewer can toggle, active only, and a row cap. New alarms appear live; resolved rows fade out.
Acknowledging and clearing alarms is done on the alarm itself. See Working with alarms.
Activity feed
Events in time order, each with a coloured marker. Bind a table with a time column and a title column.
| Setting | Values and defaults |
|---|---|
| Time column, Title column, Description column | time, title, description. A row without a title is not shown. |
| Severity column | A colour, a colour name (success, warning, error, info, neutral, primary), a status word (Critical, Warning, Online…) or a value named in Severity colours |
| Order, Items shown | Newest first; 1 to 50 (10) |
| Group by day | Off |
| Time shown as | Relative by default, or a pattern such as dd.MM HH:mm |
| Severity shown as | A dot (default) or an icon |
Clicking rows
Tables can run actions on When a row is clicked, When a row is double-clicked, When a cell is clicked and from Row buttons. Typical uses: set the board’s device parameter so other cards follow the row, open the device’s page, or open a detail page of the board. A row button may run a command that uses a column of the clicked row; the server re-reads the row by its id, and the command’s own confirmation applies. See Card actions and drill-down.
The Devices and alarms template wires this for you: a click on a device or an alarm row narrows the alarm table to that device.
Download the data
Add Download data (CSV) to the card’s Card buttons. The card header then has a CSV button and an Excel button. For a table that pages on the server, the download walks the pages up to 10,000 rows; beyond that it says “Exported the first 10000 rows only.” The download holds what you may see, in the columns the query returns.
There are no scheduled reports. To keep a record, download the table, or export readings as described in Exporting data. See Exporting data.
Troubleshooting
| What you see | Cause |
|---|---|
| “Bind a table query in this widget’s settings.” | The rows slot is empty. |
| “No rows.” | Nothing matches the source’s filters or the board window. Try Ignore the board window for alarms. |
| “Showing 100 of 640 rows” | The source’s row limit. Raise Rows (at most 500) or add a parameter filter. |
| A column is missing | The query no longer declares it, or Show hides it on this screen size. |