propertyValues
Get min/max statistics for numeric or datetime properties, or list distinct values for string or boolean properties, using a property ID from findProperties.
Instructions
Get statistics or distinct values for a specific property, identified by the id field returned from findProperties. What this tool returns depends on the property type:
• number / datetime → returns { min, max } — use this to answer range, min/max, or spread questions for numeric or date fields. No findRecords aggregation needed.
• string / boolean → returns a list of all distinct values — use this to canonicalize filter values before querying.
Workflow for range/min/max questions: (1) findLabels, (2) findProperties to find the field and get its id and type, (3) call this tool with that id if type is number or datetime.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skip | No | Number of string values to skip. | |
| limit | No | Max number of string values to return. | |
| query | No | Optional text filter — only applies to string properties. | |
| orderBy | No | Sort order for string value lists. | |
| propertyId | Yes | The `id` field from the property object returned by findProperties. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| propertyValues | Yes |