分页查询表单数据

接口总述

栏目 说明 备注
所属服务/应用 lcp-data
接口地址 /openapi/{appId或appCode}/{formClassId或formClassCode}/search
请求方式 POST
请求数据格式 JSON
返回数据格式 JSON
鉴权方式 IAC/JWT

请求头信息

参数名 数据类型 是否必填 说明 备注
x-app-id String 是 应用ID 也可以放入路径参数中
x-tenant-id String 是 租户ID 也可以放入路径参数中
x-auth-token String 否 JWT鉴权token
x-iac-token String 否 IAC鉴权token

路径参数说明

参数名 数据类型 是否必填 说明 备注
appId或appCode String 是 应用ID/应用编码
formClassId或formClassCode String 是 表单分类ID/表单分类编码

请求体说明

参数名 数据类型 是否必填 说明 备注
returnAttrsMap Map<String, List> 否 指定返回字段，默认返回所有 key：大写表名；value：返回字段
mainParamsGroups List< ParamsGroup > 否 查询条件
onlyMain Boolean 否 是否只返回主表数据，默认为false
sortBy String 否 排序字段和规则
keyType String 否 指定返回字段名的命名方式 可选值：UPPER(大写)/LOWER(小写)/CAMEL(驼峰)，默认为UPPER
page Number 否 页码，默认为1
pageSize Number 否 分页大小，默认为20

ParamsGroup说明

参数名 数据类型 是否必填 说明 备注
andOr String 否 逻辑运算符 可选值：and/or，默认为and
paramsList List< Params > 是 查询条件列表

Params说明

参数名 数据类型 是否必填 说明 备注
attrApi String 是 属性编码 大写
value Object 是 属性值
operator String 否 关系运算符 可选值：=/!=/>/>=/</<=/in/like，默认为=或in
andOr String 否 逻辑运算符 可选值：and/or，默认为and

入参示例

{
    "onlyMain": false,
    "mainParamsGroups": [
        {
            "paramsList": [
                {
                    "attrApi": "SCHOOL_NAME",
                    "operator": "like",
                    "value": "大学"
                }
            ]
        },
        {
            "paramsList": [
                {
                    "attrApi": "CAMPUS_AREA",
                    "operator": ">",
                    "value": "100"
                }
            ]
        }
    ],
    "sortBy": "CRT_TIME desc",
    "keyType": "CAMEL"
}

出参说明

参数名 数据类型 是否必填 说明 备注
status String 是 状态码
message String 是 状态信息
data FormDataVO 否 表单数据

FormDataVO说明

参数名 数据类型 是否必填 说明 备注
mainData Map<String, Object> 是 主表数据 字段名和真实值，字段名按入参keyType指定的方式命名
bizDataMap Map<String, List<Map<String, Object>>> 否 明细表数据 明细表名使用大写下划线命名，字段名按入参keyType指定的方式命名

出参示例

{
    "status": "0",
    "message": "success",
    "data": [
        {
            "id": null,
            "mainData": {
                "dversionNo": 1,
                "campusArea": 8000,
                "createPerson": "huangzebin",
                "schoolAddress": "广东省广州市天河区",
                "rowId": 1,
                "deleteFlag": "0",
                "classId": "fd056635ed2e4372953d4e8e3c434193",
                "updUser": "huangzebin",
                "createTime": 1672902741000,
                "updTime": 1672903030000,
                "appId": "09195976a9654960b60506f4023890b4",
                "isEnabled": "1",
                "tenantId": "c518f53d-b405-4111-afe1-5c082b284971",
                "id": "41e7f6bc50414cf3849242db36235fb8",
                "schoolName": "华南农业大学"
            },
            "bizDataMap": {
                "LCP_CAMPUS_2": [
                    {
                        "dversionNo": 2,
                        "crtDate": 1672902741000,
                        "crtName": "黄泽彬",
                        "campusId": "20f6ae4fd4854b18b5507b118aee2247",
                        "description": "五山校区",
                        "updName": "黄泽彬",
                        "updHost": "127.0.0.1",
                        "crtUser": "huangzebin",
                        "parentId": "-1",
                        "classId": "fd056635ed2e4372953d4e8e3c434193",
                        "isDeleted": "0",
                        "updUser": "huangzebin",
                        "updTime": 1672903030000,
                        "appId": "09195976a9654960b60506f4023890b4",
                        "isEnabled": "1",
                        "objId": "41e7f6bc50414cf3849242db36235fb8",
                        "tenantId": "c518f53d-b405-4111-afe1-5c082b284971",
                        "crtHost": "127.0.0.1"
                    }
                ],
                "LCP_MAJOR_2": [
                    {
                        "dversionNo": 2,
                        "majorCount": 30,
                        "crtName": "黄泽彬",
                        "crtTime": 1672902741000,
                        "updName": "黄泽彬",
                        "updHost": "127.0.0.1",
                        "updateTime": 1672903030000,
                        "crtUser": "huangzebin",
                        "tId": "c518f53d-b405-4111-afe1-5c082b284971",
                        "parentId": "-1",
                        "classId": "fd056635ed2e4372953d4e8e3c434193",
                        "isDeleted": "0",
                        "objId": "41e7f6bc50414cf3849242db36235fb8",
                        "crtHost": "127.0.0.1",
                        "majorName": "兽医",
                        "id": "cef661518fa74ef3b296d546c8a1785e",
                        "aId": "09195976a9654960b60506f4023890b4",
                        "enableFlag": "1",
                        "majorDescription": "培养最厉害的宠物医生",
                        "updatePerson": "huangzebin"
                    }
                ]
            }
        },
        {
            "id": null,
            "mainData": {
                "dversionNo": 3,
                "campusArea": 200,
                "updName": "黄泽彬",
                "createPerson": "yeduanwang",
                "updHost": "172.17.225.209",
                "schoolAddress": "广东省广州市番禺区",
                "rowId": 2,
                "deleteFlag": "0",
                "classId": "fd056635ed2e4372953d4e8e3c434193",
                "updUser": "huangzebin",
                "createTime": 1672135090000,
                "updTime": 1672900796000,
                "appId": "09195976a9654960b60506f4023890b4",
                "isEnabled": "1",
                "tenantId": "c518f53d-b405-4111-afe1-5c082b284971",
                "id": "3b762b84cd6b47b29f1193673b32f5f4",
                "schoolName": "华南理工大学"
            },
            "bizDataMap": {
                "LCP_CAMPUS_2": [
                    {
                        "crtDate": 1672886907000,
                        "crtName": "黄泽彬",
                        "campusId": "ec558d9c92a0415a81618ab63aab1a39",
                        "description": "大学城校区",
                        "updName": "黄泽彬",
                        "updHost": "172.29.242.157",
                        "crtUser": "huangzebin",
                        "parentId": "-1",
                        "classId": "fd056635ed2e4372953d4e8e3c434193",
                        "isDeleted": "0",
                        "updUser": "huangzebin",
                        "updTime": 1672900797000,
                        "appId": "09195976a9654960b60506f4023890b4",
                        "isEnabled": "1",
                        "objId": "3b762b84cd6b47b29f1193673b32f5f4",
                        "tenantId": "c518f53d-b405-4111-afe1-5c082b284971",
                        "crtHost": "172.29.71.119"
                    }
                ],
                "LCP_MAJOR_2": [
                    {
                        "majorCount": 20,
                        "crtName": "叶端旺",
                        "crtTime": 1672135090000,
                        "updName": "黄泽彬",
                        "updHost": "172.29.242.157",
                        "updateTime": 1672900797000,
                        "crtUser": "yeduanwang",
                        "tId": "c518f53d-b405-4111-afe1-5c082b284971",
                        "parentId": "-1",
                        "classId": "fd056635ed2e4372953d4e8e3c434193",
                        "isDeleted": "0",
                        "objId": "3b762b84cd6b47b29f1193673b32f5f4",
                        "crtHost": "172.17.227.116",
                        "majorName": "建筑学",
                        "id": "7a7663fca8e84b9e918338d4077fea0b",
                        "aId": "09195976a9654960b60506f4023890b4",
                        "enableFlag": "1",
                        "majorDescription": "培养世界顶尖工程师",
                        "updatePerson": "huangzebin"
                    }
                ]
            }
        },
        {
            "id": null,
            "mainData": {
                "dversionNo": 3,
                "campusArea": 500,
                "updName": "黄泽彬",
                "createPerson": "yeduanwang",
                "updHost": "172.17.225.209",
                "schoolAddress": "广东省珠海市",
                "rowId": 3,
                "deleteFlag": "0",
                "classId": "fd056635ed2e4372953d4e8e3c434193",
                "updUser": "huangzebin",
                "createTime": 1672132656000,
                "updTime": 1672902535000,
                "appId": "09195976a9654960b60506f4023890b4",
                "isEnabled": "1",
                "tenantId": "c518f53d-b405-4111-afe1-5c082b284971",
                "id": "f24c12257bb5465ca3725adb64dc0a2d",
                "schoolName": "中山大学"
            },
            "bizDataMap": {
                "LCP_CAMPUS_2": [
                    {
                        "crtDate": 1672899839000,
                        "crtName": "黄泽彬",
                        "campusId": "8bde7232f8194a49987ab3a864f81430",
                        "description": "珠海校区",
                        "updName": "黄泽彬",
                        "updHost": "172.17.225.209",
                        "crtUser": "huangzebin",
                        "parentId": "-1",
                        "classId": "fd056635ed2e4372953d4e8e3c434193",
                        "isDeleted": "0",
                        "updUser": "huangzebin",
                        "updTime": 1672902535000,
                        "appId": "09195976a9654960b60506f4023890b4",
                        "isEnabled": "1",
                        "objId": "f24c12257bb5465ca3725adb64dc0a2d",
                        "tenantId": "c518f53d-b405-4111-afe1-5c082b284971",
                        "crtHost": "172.29.71.119"
                    }
                ],
                "LCP_MAJOR_2": [
                    {
                        "majorCount": 100,
                        "crtName": "叶端旺",
                        "crtTime": 1672132656000,
                        "updName": "黄泽彬",
                        "updHost": "172.17.225.209",
                        "updateTime": 1672902535000,
                        "crtUser": "yeduanwang",
                        "tId": "c518f53d-b405-4111-afe1-5c082b284971",
                        "parentId": "-1",
                        "classId": "fd056635ed2e4372953d4e8e3c434193",
                        "isDeleted": "0",
                        "objId": "f24c12257bb5465ca3725adb64dc0a2d",
                        "crtHost": "172.17.227.116",
                        "majorName": "大数据技术",
                        "id": "2693bd77908b436e8830606c139b5476",
                        "aId": "09195976a9654960b60506f4023890b4",
                        "enableFlag": "1",
                        "majorDescription": "培养大数据人才",
                        "updatePerson": "huangzebin"
                    }
                ]
            }
        }
    ]
}
作者：黄泽彬  创建时间：2023-03-07 16:07
最后编辑：聂维  更新时间：2024-12-11 10:09