- Add display modes for query results: table (default), single value, and pie chart
- Single value mode supports text and numeric values, with single or multiple row layouts (label | value)
- Pie chart mode with configurable value and label columns, optional legend and percentages, and tooltips on slices showing label and value
- Added backend caching of query results.
- Added option to allow end user to bypass cache and fetch new results.
- Update directus extension sdk
- Fix sorting not working after performance update
- Fix export to include correct headers on items
- Improve table rendering performance by using lazy rendering
- Add active state on last row clicked
- Only refetched if variables involved in query were actually changed
- Fix setting of variable
- Added and hover style for on row click
- Add ability to set variables on clicking actions as an alternative to linking to page
- This allows you to set global variables in the dashboard to update other panels
- Fix issue with cache-control header being set as array instead of string
- Fix row height when items are less than full height of table
- Change default column width from 100ch to 10ch
- Add cache option to adjust how long the results are cached for
⚠️ Defaults to 300 seconds, ie. 5min (previous default was 30 seconds)- Does update when variables change
- Improved feedback on missing variables (uses info instead of error)
- Support sqlite and mssql
- Partial support for 'CALL' statements
- Add event emitter to allow other extensions to listen to events
- 'sql-query:request' - Fired before variables are replaced in the query
- 'sql-query:response' - Fired after the query has been executed
- Update sumary row basedo on searched results
First release