{"sql":"select bw.id                      as 流程任务id,\n       bw.activityCode            as 任务节点id,\n       bw.activityName            as 任务节点名称,\n       bw.instanceId              as 流程实例id,\n       bw.participant             as 任务处理人id,\n       bw.participantName         as 任务处理人姓名,\n       hou.departmentId           as 处理人部门id,\n       hod.name                   as 处理人部门名称,\n       bw.startTime               as 任务接收时间,\n       bw.state                   as 任务状态,\n       bw.workflowCode            as 流程模版编码,\n       wh.workflowName            as 流程模板名称,\n       bwi.schemaCode             as 所属模型编码,\n       haf.name                   as 所属模型名称,\n       bw.appCode                 as 所属应用编码,\n       hap.name                   as 所属应用名称,\n       bw.originator              as 流程发起人id,\n       bw.originatorName          as 流程发起人姓名,\n       bw.departmentId            as 发起人部门id,\n       bw.departmentName          as 发起人部门名称,\n       bwi.startTime              as 流程发起时间,\n       bw.originatorDeptQueryCode as 部门查询字段\nfrom biz_workitem bw\n         left join biz_workflow_instance bwi on bw.instanceId = bwi.id\n         left join h_workflow_header wh on bw.workflowCode = wh.workflowCode\n         left join h_org_user hou on bw.participant = hou.id\n         left join h_org_department hod on hou.departmentId = hod.id\n         left join h_app_function haf on bwi.schemaCode = haf.code\n         left join h_app_package hap on bw.appCode = hap.code\n","title":"待办任务","dbConfig":null,"encrypted":true,"dynamicParams":null}