add_dataset_filter
Add a filter to a dataset by specifying expression, operator, and values. Returns the filter index for easy removal.
Instructions
Append a to the named dataset's block. operator ∈ Equal / NotEqual / GreaterThan / LessThan / GreaterThanOrEqual / LessThanOrEqual / Like / In / Between / TopN / BottomN / TopPercent / BottomPercent. values must be non-empty (single-value filters use a one-element list). Returns the new filter's index for later removal. Optional field_format wraps the expression as Format(, fmt) to coerce typed fields for string-parameter comparison. Response includes warnings for field/parameter type mismatches detected via best-effort cross-check.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>",
"dataset_name": "<dataset_name>",
"expression": "<expression>",
"operator": "<operator>",
"values": "<values>"
},
"name": "add_dataset_filter"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| values | Yes | ||
| operator | Yes | ||
| expression | Yes | FilterExpression — usually a Fields! reference. | |
| dataset_name | Yes | ||
| field_format | No | Optional format string (e.g. 'MMM, yyyy') wrapping the expression as Format(<body>, '<fmt>'). |