get_report
Fetch and analyze QMSCloud ticket reports from Metabase. Get summaries by status, service, branch, counter, and business date, with waiting/serving times. Optionally list individual tickets with times.
Instructions
Fetch a QMSCloud report from Metabase and analyze it to answer the user's question. Returns a compact summary (distinct tickets; breakdowns by status, service, branch, counter, business date; a ticket_numbers list; and waiting/serving-time stats) plus a few sampleRows. For questions that require listing individual tickets WITH their times, pass detail=true to also get a per-ticket table. Pass the exact report key (call list_reports if unsure). Supply start_date/end_date as YYYY-MM-DD from the user's intent (defaults to current month-to-date). The tenant (company/branch) is resolved automatically from the workspace — do not ask the user for it. Currently available: 'ticket_summary'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| detail | No | Set true when the user wants to LIST individual tickets with their times (issued/called/completed, waiting/serving minutes). Adds a compact `summary.tickets` table. Default false (aggregates only). | |
| report | Yes | Exact report key, e.g. 'ticket_summary'. See list_reports. | |
| end_date | No | End date YYYY-MM-DD. Defaults to today. | |
| start_date | No | Start date YYYY-MM-DD. Defaults to the first of the current month. | |
| include_rows | No | Rarely needed. If true, also returns every raw row with all columns (large, GUID-heavy). Prefer `detail` for per-ticket listing. Default false. | |
| workspace_slug | Yes | Internal: identifies which QMSCloud tenant to query. Injected automatically by the AnythingLLM host on every call — do not ask the user for it and do not set it yourself. |