advanced-filter-list-entries
Filter CRM list entries using multiple conditions to perform complex sales pipeline queries and find specific records based on attribute criteria.
Instructions
Filter entries in a CRM list with advanced multiple conditions (complex sales pipeline queries)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filters | Yes | Advanced filter configuration | |
| limit | No | Maximum number of entries to fetch (default: 20) | |
| listId | Yes | ID of the list to filter entries from | |
| offset | No | Number of entries to skip for pagination (default: 0) |
Input Schema (JSON Schema)
{
"properties": {
"filters": {
"description": "Advanced filter configuration",
"properties": {
"filters": {
"description": "Array of filter conditions",
"items": {
"properties": {
"attribute": {
"properties": {
"slug": {
"description": "Slug of the attribute to filter by (e.g., 'stage', 'status')",
"type": "string"
}
},
"required": [
"slug"
],
"type": "object"
},
"condition": {
"description": "Filter condition (e.g., 'equals', 'contains', 'greater_than')",
"enum": [
"equals",
"not_equals",
"contains",
"not_contains",
"starts_with",
"ends_with",
"greater_than",
"less_than",
"greater_than_or_equals",
"less_than_or_equals",
"is_empty",
"is_not_empty",
"is_set",
"is_not_set"
],
"type": "string"
},
"logicalOperator": {
"description": "Logical operator to use with the next filter (default: 'and')",
"enum": [
"and",
"or"
],
"type": "string"
},
"value": {
"description": "Value to filter by (type depends on the attribute)"
}
},
"required": [
"attribute",
"condition",
"value"
],
"type": "object"
},
"type": "array"
},
"matchAny": {
"description": "When true, at least one filter must match (OR logic). When false, all filters must match (AND logic). Default: false",
"type": "boolean"
}
},
"required": [
"filters"
],
"type": "object"
},
"limit": {
"description": "Maximum number of entries to fetch (default: 20)",
"type": "number"
},
"listId": {
"description": "ID of the list to filter entries from",
"type": "string"
},
"offset": {
"description": "Number of entries to skip for pagination (default: 0)",
"type": "number"
}
},
"required": [
"listId",
"filters"
],
"type": "object"
}