fluent_query
Read-only
Build and run ServiceNow database queries with filters, field selection, sorting, limits, and aggregations. Retrieve records or compute COUNT, AVG, SUM, MIN, MAX results.
Instructions
GlideQuery-style fluent query builder. Supports select, where, aggregate (COUNT/AVG/SUM/MIN/MAX), orderBy, limit, and groupBy. Returns records or aggregate results. Example: { table: "incident", where: [["active","=",true],["priority","<",3]], select: ["number","short_description"], limit: 10 }
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max records to return (default: 20, max: 200) | |
| table | Yes | Table name (e.g., "incident") | |
| where | No | Array of conditions: [field, operator, value]. Operators: =, !=, >, >=, <, <=, LIKE, STARTSWITH, CONTAINS, IN, NOT IN, ISEMPTY, ISNOTEMPTY | |
| select | No | Fields to return. Supports dot-walking (e.g., "caller_id.email"). If omitted, returns all fields. | |
| groupBy | No | Field to group results by (for aggregate queries) | |
| orWhere | No | Array of OR conditions (same format as where) | |
| orderBy | No | Field to sort by. Prefix with "-" for descending. | |
| aggregate | No | Aggregate operation: COUNT, AVG, SUM, MIN, MAX | |
| displayValue | No | Return display values instead of internal values (default: false) | |
| aggregateField | No | Field to aggregate on (required for AVG, SUM, MIN, MAX) |