|
发表于 2024-11-1 17:26:29
|
显示全部楼层
借助查询配置,原生Sql脚本,分析了实例数据(存储在qry_item)和pp_c_work、pp_c_workcompleted组合拼接成sql进行查询,返回结果,查询可以做到:
1、查询条件字段:表单xformId、应用xapplication、流程xprocessId,流程名xprocessName,如:
[{"value":"借款","path":"xprocessName","formatType":"textValue","logic":"and","comparison":"like"}]
2、查询某个实例的字段值,如:某个员工(表单对应的字段标识txtApplication):
[{"value":"xxx","path":"txtApplicant.0.dn","formatType":"textValue","logic":"and","comparison":"like"}]
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?立即注册
x
|