两个筛选项 机构编码 机构名称选择机构编码("AS001","BD002") 机构名称筛选出 ("鞍山第一厂","保定第二厂")但是选择机构名称后 机构编码已经选择的会丢失两个数据集为编码: select org_no from table1 where 1=1 ${if(len(p_org_name) == 0,"","and coalesce(base_org_name,'1') in ('" + p_org_name + "')")}名称: select org_name from table1 where 1=1 ${if(len(p_org_no) == 0,"","and coalesce(base_org_no,'1') in ('" + p_org_no + "')")}
