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