propertyValues
Retrieves min/max statistics for numeric or datetime properties and distinct values for string/boolean fields, enabling range queries and filter value canonicalization.
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.
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": {
"propertyId": "<propertyId>"
},
"name": "propertyValues"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skip | No | Number of string values to skip. | |
| limit | No | Max number of string values to return. | |
| match | No | How `query` matches (default contains). `similar` finds near spellings (spiderman → Spider-Man). | |
| query | No | Optional text filter: keep the values whose text matches (strings as stored; numbers and dates as shown; a date such as 1993/11/12 or 2013-06 also matches that date in another layout). Matching values come ranked by record count, with counts. | |
| orderBy | No | Sort order for string value lists. | |
| propertyId | Yes | The `id` field from the property object returned by findProperties. | |
| domainOnMiss | No | When nothing matches and the property holds at most this many distinct values, return all of them instead (searchMissed: true): the data may store the idea as a code ("positive" → "+"). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| propertyValues | Yes |