HighReport报表工具支持Json数据格式数据集，支持各种复杂Json数据格式
1.HighReport是报表对Json数据支持最强的，原因有二
1.独立自主研发的Json数据解析引擎
2.独立自主研发的JsonPath解析引擎
JsonPath支持父路径定位，这样就可以实现一些高级Json报表
| 序号 | 节点 | 说明 |
| 1 | * | 所有节点 |
| 2 | . | 当前节点 |
| 3 | .. | 父节点 |
| 4 | rows | 节点名称 |
| 5 | [] | 节点属性 |
举例
abc/*/efg
abc/*/efg[id==3]
abc/*/efg[id==3 && name=="test"]
为啥研发JsonPah，因为标准的JsonPath库有些功能不支持
2.复杂Json数据示例
{
"message": {
"header": {
"auth": {
"callerid": "1552267812363",
"license": "9425846d54cf43434b7d81dd6b922fa75",
"token": "392c952d-9c0e-1342-9987-29d6d8319182",
"ipaddr": null,
"macaddr": null
},
"servicecode": {
"systemcode": "",
"busscode": "",
"version": "1",
"apiurl": "/jmzz-y12-blzk/key-query/danger-patient/list"
},
"response": {
"code": 1,
"excode": null,
"text": null,
"detail": null
}
},
"body": {
"bussresponse": {
"code": "1",
"excode": "",
"text": "请求成功",
"detail": ""
},
"queryresponse": {
"pageno": 1,
"pagesize": 10,
"pagecount": 7,
"recordcount": 62,
"sortfiled": null,
"sorttype": null
},
"datacompress": null,
"dataencrypt": null,
"dataset": [
{
"name": "list",
"row": [
{
"aid": 219619,
"patientId": 100022078,
"institutionId": 1,
"bedNum": "0016",
"patientStatus": 1,
"conditionState": 1,
"patientName": "杨二幂",
"deptId": 1069,
"deptName": "住院骨科",
"inpatinetAreaId": 1068,
"inpatinetArea": "骨科病区",
"patientSexId": 1,
"patientSex": "男",
"patientAge": "20岁",
"inhosapplyDate": "2020-05-14 15:57:35",
"outhosapplayDate": null,
"patientPersonId": 591,
"medicalRecordNum": "",
"hospitalId": "02000110",
"doctorGroupId": 100,
"doctorGroupName": "骨科诊疗组",
"nursingGroupId": 79,
"nursingGroupName": "骨科护理组",
"bedDoctorId": 1741,
"bedDoctor": "江二峰",
"bedNurId": 1743,
"bedNur": "陈二红",
"chargeDoctorId": 1741,
"chargeDoctor": "江二峰",
"directorDoctorId": 1741,
"directorDoctor": "江峰",
"inhosImpName": "乙型病毒性肝炎",
"inhosImpDate": "2021-07-23 11:28:36",
"dangerDate": "2020-08-03 16:46:00"
},
{
"aid": 10343,
"patientId": 100022078,
"institutionId": 1,
"bedNum": "0016",
"patientStatus": 1,
"conditionState": 2,
"patientName": "杨二幂",
"deptId": 1069,
"deptName": "住院骨科",
"inpatinetAreaId": 1068,
"inpatinetArea": "骨科病区",
"patientSexId": 1,
"patientSex": "男",
"patientAge": "20岁",
"inhosapplyDate": "2020-05-14 15:57:35",
"outhosapplayDate": null,
"patientPersonId": 591,
"medicalRecordNum": "",
"hospitalId": "02000110",
"doctorGroupId": 100,
"doctorGroupName": "骨科诊疗组",
"nursingGroupId": 79,
"nursingGroupName": "骨科护理组",
"bedDoctorId": 1741,
"bedDoctor": "江二峰",
"bedNurId": 1743,
"bedNur": "陈二红",
"chargeDoctorId": 1741,
"chargeDoctor": "江二峰",
"directorDoctorId": 1741,
"directorDoctor": "江二峰",
"inhosImpName": "乙型病毒性肝炎",
"inhosImpDate": "2021-07-23 11:28:36",
"dangerDate": "2020-05-23 12:15:14"
}
]
}
]
},
"extend": null
}
}
3.报表设置Json数据集
支持WebApi标准接口
报表左边展示Json数据层次结构，支持对象、属性和数组
数据结构是2个不同的子节点数组
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
