Appearance
Table Widget
Last updated
A table of live tag values, or of the rows a query returns.
Settings
| Setting | Shown for | Description | Default |
|---|---|---|---|
| Data Source | all | Tag Bindings, Custom SQL Query or Named Query | Tag Bindings |
| SQL Query | Custom SQL Query | Admin-authored SELECT against the local or a remote database | — |
| Named Query | Named Query | A read query and its parameter values | — |
| Refresh (ms) | query sources | Re-run interval | 15000 |
Tag Bindings mode
Add one binding per row. The left column shows the tag path (or the binding name for static and expression bindings); the right column the current value, as raw text with no formatting. A missing value shows —.
Query modes
Every column the query returns becomes a column, in query order; the header shows "n rows". Nulls show as a gray null. Query errors are shown in red inside the widget, for example "Only read-only SELECT queries are allowed" or "Query must return rows".
- Custom SQL Query: only administrators can write or change the SQL (with Preview query); at most 1,000 rows. Other users see the results of the query saved on the dashboard.
- Named Query: results respect the query's own role list — a user outside it sees the error "You do not have permission to run …". A query that modifies data cannot be used here.