2.10.22版本，自定义SQL，定义了参数，查询组件绑定参数后不生效。
select l.host_id 主播ID,
l.host_name 主播名称,
l.session_name 场次名称,
l.audience_douyin_id 观众抖音号,
(select case when count()>1 then ‘是’ else ‘否’ end from live_audience la where la.audience_douyin_id=l.audience_douyin_id
and $DE_PARAM{la.host_name in ($[sessionName])} group by la.audience_douyin_id having count()>1) 重复出现观众
from live_audience l
where $DE_PARAM{l.host_name in ($[sessionName])}
数据库日志显示：
SELECT DISTINCT t_a_0.f_a50ecfa3eecea592 AS f_ax_0 FROM (SELECT t_a_0.主播ID AS f_6163b873074968e1,t_a_0.主播名称 AS f_0dc5a498dfe6caa1,t_a_0.场次名称 AS f_a50ecfa3eecea592,t_a_0.观众抖音号 AS f_c16ab6057305e7f0,t_a_0.重复出现观众 AS f_08bf7ef30e401326 FROM (select l.host_id 主播ID,
l.host_name 主播名称,
l.session_name 场次名称,
l.audience_douyin_id 观众抖音号,
(select case when count()>1 then ‘是’ else ‘否’ end from live_audience la where la.audience_douyin_id=l.audience_douyin_id and ‘DE-BI’ = ‘DE-BI’ group by la.audience_douyin_id having count()>1) 重复出现观众
from live_audience l
where ‘DE-BI’ = ‘DE-BI’ ) t_a_0) AS t_a_0 LIMIT 1000 OFFSET 0