(case when sp.status != '' then (select label from scm_sys_dict where type = 'projectState' and code = sp.project_status) else '' end) as projectStatus,
sp为外层结果表
like 使用
like '%' || #{qyName} || '%'
(case when sp.status != '' then (select label from scm_sys_dict where type = 'projectState' and code = sp.project_status) else '' end) as projectStatus,
sp为外层结果表
like 使用
like '%' || #{qyName} || '%'