SELECT
NVL (
tab.node_name,
'结束节点'
)AS nodename,
handlernames,
fd_date,
fd_phone_num
FROM
ekp_frzs_stu gbwc
LEFT JOIN sys_org_element e1 ON E1.fd_id = gbwc.fd_name
LEFT JOIN (
SELECT
nodes.fd_fact_node_name AS node_name,
hand_tab.*, pro.fd_model_id
FROM
(
SELECT
LISTAGG (el.FD_NAME, ',') WITHIN GROUP (ORDER BY lbp.fd_process_id) AS handlerNames,
lbp.fd_process_id
FROM
LBPM_EXPECTER_LOG lbp
LEFT JOIN SYS_ORG_ELEMENT el ON LBP.FD_HANDLER_ID = el.fd_id
LEFT JOIN LBPM_NODE node ON node.fd_process_id = LBP.fd_process_id
GROUP BY
lbp.fd_process_id
) hand_tab
LEFT JOIN LBPM_PROCESS pro ON pro.fd_id = hand_tab.fd_process_id
LEFT JOIN LBPM_NODE nodes ON nodes.fd_process_id = pro.fd_id
) tab ON tab.fd_model_id = gbwc.fd_id
where gbwc.fd_id='{fd_id}'
大佬帮忙看一下,是哪里出错了呢
十分抱歉,您这个问题我这边不太了解,无法给您正确的解决方法
mysql配置文件的问题,百度一下分分钟解决