Query History and Result Tools
Query History and Result Tools
Query history
Every executed query is saved locally in the browser (up to 20 per connection). Open History to browse, load, or clear past executions.
Saved queries are different — they are named statements stored on the server. See [[product:ol-dataiq/saved-queries|Saved Queries]].
Result tools
- Pagination — toggle below the editor; page size follows System Settings → Query Settings
- Column sorting — click headers to add or update
ORDER BY - Search — filter rows across all columns with inline highlighting
- Column resize — drag column edges (50–600px)
- CSV — copy to clipboard or download
- Add Record — insert a row via form for single-table
SELECT *results
Export
Export Dataset… moves result data to another connection or creates Hub ETL / DB Poller projects (when Hub is configured).
Reuse query history and saved queries; sort, filter, paginate, resize, and export results.