FindRecords
Search and filter database records using queries, labels, sorting, and aggregation to retrieve specific data from RushDB.
Instructions
Find records in the database using a search query
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| aggregate | No | Aggregation definitions (records only) | |
| groupBy | No | Fields to group by (records only) | |
| labels | No | Filter by record labels | |
| limit | No | Maximum number of records to return | |
| orderBy | No | Sorting configuration: key = field, value = asc|desc | |
| skip | No | Number of records to skip | |
| where | No | Search conditions for finding records |
Input Schema (JSON Schema)
{
"properties": {
"aggregate": {
"additionalProperties": {
"properties": {
"alias": {
"description": "Optional alias override",
"type": "string"
},
"field": {
"description": "Field to aggregate",
"type": "string"
},
"fn": {
"description": "Aggregation function (count,sum,avg,min,max,timeBucket)",
"type": "string"
},
"granularity": {
"description": "For timeBucket, the time granularity (e.g., day, week, month, quarter, year)",
"type": "string"
}
},
"required": [
"fn"
],
"type": "object"
},
"description": "Aggregation definitions (records only)",
"type": "object"
},
"groupBy": {
"description": "Fields to group by (records only)",
"items": {
"type": "string"
},
"type": "array"
},
"labels": {
"description": "Filter by record labels",
"items": {
"type": "string"
},
"type": "array"
},
"limit": {
"default": 10,
"description": "Maximum number of records to return",
"type": "number"
},
"orderBy": {
"additionalProperties": {
"enum": [
"asc",
"desc"
],
"type": "string"
},
"description": "Sorting configuration: key = field, value = asc|desc",
"type": "object"
},
"skip": {
"default": 0,
"description": "Number of records to skip",
"type": "number"
},
"where": {
"description": "Search conditions for finding records",
"type": "object"
}
},
"required": [],
"type": "object"
}