高级筛选

POST

http://127.0.0.1:9999/model/{model-name}/filter

请求参数

Path 参数

Body 参数application/json

示例

{
    "querys": [
        [
            {
                "operation": "LIKE",
                "name": "name",
                "value": "名称查询"
            }
        ],
        [
            {
                "operation": "EQUAL",
                "name": "id",
                "value": 1
            }
        ]
    ],
    "sorter": [
        {
            "property": "id",
            "direction": "DESC"
        },
        {
            "property": "name",
            "direction": "DESC"
        }
    ],
    "pageNum": 1,
    "pageSize": 10,
    "view": {},
    "columns": [
        "id",
        "name"
    ]
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'http://127.0.0.1:9999/model//filter' \
--header 'Content-Type: application/json' \
--data-raw '{
    "querys": [
        [
            {
                "operation": "LIKE",
                "name": "name",
                "value": "名称查询"
            }
        ],
        [
            {
                "operation": "EQUAL",
                "name": "id",
                "value": 1
            }
        ]
    ],
    "sorter": [
        {
            "property": "id",
            "direction": "DESC"
        },
        {
            "property": "name",
            "direction": "DESC"
        }
    ],
    "pageNum": 1,
    "pageSize": 10,
    "view": {},
    "columns": [
        "id",
        "name"
    ]
}'

返回响应

🟢200OK

application/json

Body

示例

{
    "code": 0,
    "data": {
        "orderBys": "string",
        "pageNum": 0,
        "pageSize": 0,
        "rows": [
            {
                "property1": {},
                "property2": {}
            }
        ],
        "total": 0
    },
    "message": "string"
}

🟢201Created

🟠401Unauthorized

🟠403Forbidden

🟠404Not Found

修改于 2023-02-16 00:48:26

批量新增或修改（有id则根据id修改,否则新增）

加载符合条件的第一条