{"sql":"select \"wi\".\"id\" as \"任务Id\", \"wi\".\"appCode\" as \"所属应用编码\", \"hap\".\"name\" as \"所属应用名称\", \"wi\".\"workflowCode\" as \"所属流程编码\", \"hwh\".\"workflowName\" as \"所属流程名称\", \"wi\".\"activityCode\" as \"节点编码\", \"wi\".\"activityName\" as \"节点名称\", \"wi\".\"participant\" as \"任务处理人id\", \"wi\".\"participantName\" as \"任务处理人姓名\", \"hou\".\"departmentId\" as \"任务处理部门id\", \"hod\".\"name\" as \"任务处理人部门名称\", \"wi\".\"startTime\" as \"创建时间\", \"wi\".\"receiveTime\" as \"处理时间\", \"wi\".\"originatorDeptQueryCode\" as \"部门查询字段\" from (select \"id\", \"appCode\", \"workflowCode\", \"activityCode\", \"participant\", \"participantName\", \"startTime\", \"receiveTime\", \"activityName\", \"originatorDeptQueryCode\" from \"biz_workitem\" union all select \"id\", \"appCode\", \"workflowCode\", \"activityCode\", \"participant\", \"participantName\", \"startTime\", \"receiveTime\", \"activityName\", \"originatorDeptQueryCode\" from \"biz_workitem_finished\") \"wi\" left join \"h_app_package\" \"hap\" on \"wi\".\"appCode\" = \"hap\".\"code\" left join \"h_workflow_header\" \"hwh\" on \"wi\".\"workflowCode\" = \"hwh\".\"workflowCode\" left join \"h_org_user\" \"hou\" on \"wi\".\"participant\" = \"hou\".\"id\" left join \"h_org_department\" \"hod\" on \"hou\".\"departmentId\" = \"hod\".\"id\"","title":"所有任务","dbConfig":null,"encrypted":true,"dynamicParams":null}