这个字典数据集sql语句截图贴一下看看
with temp AS (
SELECT '20'||t.organ_id_4 AS code4
,'('||t.organ_id_4||')'||t.organ_name_4 AS name4
,'20'||t.organ_id_3 AS col1
,'20'||t.organ_id_4 AS col2
FROM P_DIM_ORGAN t
WHERE 1=1
AND t.organ_level='4')
SELECT code4
,name4
FROM temp
WHERE 1=1
${IF(len(orgCode)==4," AND col1 IN ('"+org3+"')","")}
${IF(len(orgCode)==6," AND col1 = '"+orgCode+"'","")}
${if(len(orgCode)==8," AND col2 = '"+orgCode+"'","")}
${if(len(orgCode)==10," AND col2 = substr('"+orgCode+"',1,8)","")}
ORDER BY code4