{"sql":"SELECT\n\twi.id AS \"任务Id\",\n\twi.appCode AS \"所属应用编码\",\n\thap.name AS \"所属应用名称\",\n\twi.workflowCode AS \"所属流程编码\",\n\thwh.workflowName AS \"所属流程名称\",\n\twi.activityCode AS \"节点编码\",\n\twi.activityName AS \"节点名称\",\n\twi.participant AS \"任务处理人id\",\n\twi.participantName AS \"任务处理人姓名\",\n\thou.departmentid AS \"任务处理部门id\",\n\thod.name AS \"任务处理人部门名称\",\n\twi.startTime AS \"创建时间\",\n\twi.receiveTime AS \"处理时间\",\n\twi.originatorDeptQueryCode AS \"部门查询字段\" \nFROM\n\t(\n\tSELECT id,\n\t\tappCode,\n\t\tworkflowCode,\n\t\tactivityCode,\n\t\tparticipant,\n\t\tparticipantName,\n\t\tstartTime,\n\t\treceiveTime,\n\t\tactivityName,\n\t\toriginatorDeptQueryCode \n\tFROM\n\t\tbiz_workitem UNION ALL\n\tSELECT id,\n\t\tappCode,\n\t\tworkflowCode,\n\t\tactivityCode,\n\t\tparticipant,\n\t\tparticipantName,\n\t\tstartTime,\n\t\treceiveTime,\n\t\tactivityName,\n\t\toriginatorDeptQueryCode \n\tFROM\n\t\tbiz_workitem_finished \n\t) wi\n\tLEFT JOIN h_app_package hap ON wi.appCode = hap.code\n\tLEFT JOIN h_workflow_header hwh ON wi.workflowCode = hwh.workflowCode\n\tLEFT JOIN h_org_user hou ON wi.participant = hou.id \n\tLEFT JOIN h_org_department hod ON hou.departmentid = hod.id","title":"所有任务","dbConfig":null,"encrypted":true,"dynamicParams":null}