Running Queries (Level 1)¶
The simplest role in EQQ is Query User: a person who runs queries built for them. They never see the editor.
3.1 The Use Queries Page¶
Navigate: top bar → Use Queries.
The list shows only queries whose status is Active and that are visible to your role + database. Columns:
| Column | Meaning |
|---|---|
| ▶ (green) | Launch — opens the execution screen. |
| Name | Human-friendly name. Hover for full text. |
| (bulb icon) | Query Tip — help text authored by the query designer. |
| Query Type | Category assigned by the designer (e.g. Data Audit, Who or What). |
| Description | Designer's summary of what the query returns. |
Per column there is an inline search box and a sortable header. At the bottom-right: page size toggles 10 / 25 / 50 / 100.
3.2 Executing a Query¶
Click the green ▶ button in the list to open the Run Query page.
The Run Query screen is a two-step wizard (Query Parameters → Result). Three panels:
Query Information (read-only)¶
Confirms you launched the right query:
| Field | Source |
|---|---|
| Query Name | Designer-supplied friendly name. |
| Description | What the query returns, in plain language. |
| Tip | Author hint — e.g. "Different perspective from Items and the customers that ordered them." |
Result Options — how the result is delivered¶
| Control | Effect |
|---|---|
| Display Here First | Toggle — render in-app first so you can inspect before exporting. |
| Export To → EXCEL | Download as .xlsx (respects LimitRowExcelPerSheet). |
| Export To → CSV | Download as .csv — unlimited streaming. |
| Export To → JSON | Download as .json. |
| Export To → PRINT | Open a print-formatted view (for PDF via browser print). |
Query Parameters¶
Every declared parameter appears as a row with columns # / Selections / Required / Enter your value / Tip.
- A green "Required" badge means the parameter cannot be blank — the Run button stays disabled until filled.
- Selections shows a dropdown when the parameter is List-type (populated from a helper query; max size set by
ParameterListTypeLimit, default 6). - Tip is the help text authored alongside the parameter definition.
If the query has no parameters, the banner "No parameters. Just run the query." appears.
Actions¶
| Button | What it does |
|---|---|
| Clear | Reset all parameter inputs to default. |
| Run | Execute; moves to step 2 (Result) when Display Here First is on, or starts a direct download otherwise. |
| Back | Return to Use Queries list. |
| Next | Advance to Result step manually. |
3.3 Filtering, Sorting, and Paging Results¶
In the Result grid you can:
- Sort by clicking column headers (toggles asc/desc).
- Filter using the input row under each header — narrows visible rows in real time.
- Increase the in-app page size up to 100 rows; exports contain the full result.
- Large results (above
LargeQueryResultThreshhold, default 5000) stream to avoid browser freeze; a banner warns you. - Excel export cap is
LimitRowExcelPerSheet(default 1,048,576) — larger exports split across sheets or files.