Skip to main content

Running a Query

Once a query is saved you can run it from the Queries list, from the editor, or wherever it appears on a dashboard.

Running with a form​

If a query has form variables, Kvery shows a form before running. Fill in the fields and submit to execute the query with those values. Field types include text, numbers, dates, and special inputs such as checkboxes, radio buttons, and selects.

Queries that only read data (SELECT / EXEC) show a run button; queries that write data show a clearly labelled action so the side effect is explicit.

Foreground vs. background execution​

  • Foreground — you wait for the result and Kvery displays it as soon as it is ready. This is the normal, interactive mode.
  • Background — the query runs without blocking the interface. This is useful for longer-running queries and is the mechanism behind responsive dashboards, where several tiles can load independently.

Where results appear​

The result is rendered using the query's saved layout:

  • a table (sortable, searchable, paginated),
  • cards (one per row), or
  • a chart.

Timeouts​

Queries run under a timeout (100 seconds by default). If a query exceeds it, the execution is stopped and the error is recorded in the logs. For heavy workloads use scheduling or background execution, and add LIMIT/pagination where possible. See Supported databases.

Result caching​

Read queries can be cached for a short time so repeated runs return instantly. You can clear a query's cache when you need fresh data. See Export and cache.