Queries and Dashboards

Queries and dashboards

AQL is Auton8's query language. It runs over the platform's own entities — records, workflow state, notes, datasets — not over raw tables, so it respects permissions and speaks in domain terms.

The query page

Query gives you an editor with schema-aware completion. The catalogue of entities, columns and functions is read from the server, and for Records it merges in each record type's own fields, so completion knows about the schema you defined.

Shape of a query

FROM <Entity>
  WHERE <condition>
  COLUMNS(<expr> AS <alias>, …)
  GROUP(<column>)
  ORDER BY <column> [ASC|DESC]
  LIMIT <n>

Real examples:

FROM Flows WHERE StartDate >= 2w ago ORDER BY StartDate DESC

FROM Flows ORDER BY Total DESC COLUMNS(Status, COUNT() AS Total) GROUP(Status)

FROM Flows WHERE BETWEEN(StartDate, 2w ago, NOW)

Note the relative-time syntax (2w ago, NOW) and that ORDER BY can reference a COLUMNS alias.

Entities

Entity	Holds
Records	Your records, with record-type fields merged in
RecordActivityRollup	Record activity aggregated over time
Flows	Workflow runs — the entity most examples use
WorkflowExecutions, WorkflowTasks, WorkflowHistory, WorkflowVariables	The workflow domain in detail
WorkflowModels / Workflows	The models themselves
WorkflowAnalytics	Pre-aggregated shapes for charts
Notes	Notes content
Dataset	A dataset you have defined — see Data-Stores-and-Pipelines

Authorization is applied at execute time, not catalogue time: you can see that an entity exists and what columns it has, but the rows you get back are the rows you are allowed to see.

Saved queries

Save a query to reuse it, put it on a dashboard, or share it.

Sharing issues a link that runs the query for whoever visits — no Auton8 account required. Treat that as publishing the data the query returns: the link carries its own token and runs with the issuer's access, so share deliberately. Shares can be revoked.

Dashboards

Dashboard is a user-configurable grid of widgets — draggable, resizable, and saved per user where the template allows it.

Widget types available:

Widget	Use
Data table	Rows from a query, paged
Mantine chart	Standard chart types over a query result
Composite chart	Multiple series together
Quadrant chart	Two-axis scatter, for comparing populations

Each widget picks a data source — usually a saved query — and then configures itself against that result's schema, so the field pickers offer real columns rather than free text.

Dashboards can also be mounted as a page template by an administrator, which is how a curated dashboard becomes a menu item for everyone rather than a personal layout. See Administration.

Cost awareness

A dashboard is a set of queries that run whenever someone opens it. Two habits keep that cheap:

• Prefer the pre-aggregated entities (WorkflowAnalytics, RecordActivityRollup) over raw rows plus client-side maths.
• Use LIMIT on table widgets; a table nobody scrolls does not need 10,000 rows.