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.
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>'). |