query
Query specific data from a UniCloud database collection using JQL conditions, filter results by fields, apply sorting, and limit or skip records for precise retrieval.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
collection | Yes | 集合名称 | |
field | No | 返回字段 (可选) | |
limit | No | 限制返回数量 (可选) | |
orderBy | No | 排序条件 (可选) | |
skip | No | 跳过记录数 (可选) | |
where | Yes | 查询条件 (JQL格式) |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"collection": {
"description": "集合名称",
"type": "string"
},
"field": {
"additionalProperties": {},
"description": "返回字段 (可选)",
"type": "object"
},
"limit": {
"description": "限制返回数量 (可选)",
"type": "number"
},
"orderBy": {
"additionalProperties": false,
"description": "排序条件 (可选)",
"properties": {
"field": {
"type": "string"
},
"order": {
"enum": [
"asc",
"desc"
],
"type": "string"
}
},
"required": [
"field",
"order"
],
"type": "object"
},
"skip": {
"description": "跳过记录数 (可选)",
"type": "number"
},
"where": {
"additionalProperties": {},
"description": "查询条件 (JQL格式)",
"type": "object"
}
},
"required": [
"collection",
"where"
],
"type": "object"
}