Start Today

← Documentation

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.

Read more