{"sql":"select \"bwt\".\"activityCode\" as \"节点编码\", \"item\".\"activityName\" as \"节点名称\", \"bwt\".\"instanceId\" as \"流程实例id\", \"bwt\".\"startTime\" as \"开始时间\", \"bwt\".\"finishTime\" as \"结束时间\", \"bwt\".\"usedtime\" as \"耗时\", round(\"bwt\".\"usedtime\" / 1000, 2) as \"耗时（秒）\", round(\"bwt\".\"usedtime\" / 60000, 2) as \"耗时（分）\", round(\"bwt\".\"usedtime\" / 3600000, 2) as \"耗时（小时）\", round(\"bwt\".\"usedtime\" / 86400000, 2) as \"耗时（天）\", \t\t  round(\"bwt\".\"calendarUsedTime\" / 1000, 2) as \"工作日历耗时（秒）\", round(\"bwt\".\"calendarUsedTime\" / 60000, 2) as \"工作日历耗时（分）\", round(\"bwt\".\"calendarUsedTime\" / 3600000, 2) as \"工作日历耗时（小时）\", case \"bwt\".\"state\" when 'CANCELLED' then '被取消' when 'EXCEPTION' then '异常' when 'FINISHED' then '已完成' when 'REVOKE' then '被撤回' else '进行中' end as \"节点状态\", \"bwi\".\"workflowCode\" as \"流程模板编码\", \"hwh\".\"workflowName\" as \"流程模板名称\", \"bwi\".\"schemaCode\" as \"所属模型编码\", \"haf\".\"name\" as \"所属模型名称\", \"bwi\".\"appCode\" as \"所属应用编码\", \"hap\".\"name\" as \"所属应用名称\", \"bwi\".\"originatorDeptQueryCode\" as \"部门查询字段\" from \"biz_workflow_token\" \"bwt\" left join \"biz_workflow_instance\" \"bwi\" on \"bwt\".\"instanceId\" = \"bwi\".\"id\" left join \"h_workflow_header\" \"hwh\" on \"bwi\".\"workflowCode\" = \"hwh\".\"workflowCode\" left join \"h_app_function\" \"haf\" on \"bwi\".\"schemaCode\" = \"haf\".\"code\" left join \"h_app_package\" \"hap\" on \"bwi\".\"appCode\" = \"hap\".\"code\" left join (select \"instanceId\", \"activityCode\", \"activityName\" from (select \"instanceId\", \"activityCode\", \"activityName\" from \"biz_workitem_finished\" union all select \"instanceId\", \"activityCode\", \"activityName\" from \"biz_workitem\") \"all_item\" group by \"instanceId\", \"activityCode\", \"activityName\") \"item\" on \"bwt\".\"instanceId\" = \"item\".\"instanceId\" and \"bwt\".\"activityCode\" = \"item\".\"activityCode\"","title":"节点数据","dbConfig":null,"encrypted":true,"dynamicParams":null,"sqlParams":null}