这个多值模糊查询怎么把条件改成或的关系

FineReport 18730286872 发布于 2020-2-20 13:13

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：4 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共3回答

最佳回答

axingLv6专家互助
发布于2020-2-20 13:54

已QQ

where 1=1
${if(len(a)==0,"","and (regexp_like('WMS_USER_TESTER'.'AD_EXTENDMATERIAL'.AD1_MATERIALID,'"+replace(a,",","|")+"') or regexp_like('WMS_USER_TESTER'.'AD_EXTENDMATERIAL'.AD1_MATERIALNAME,'"+replace(a,",","|")+"'))")}
${if(len(b)==0,"","and (regexp_like('WMS_USER_TESTER'.'AD_RE_SHIPER_EXTENDMATERIAL'.AD13_SUPCODE,'"+replace(b,",","|")+"')or regexp_like('WMS_USER_TESTER'.'AD_SHIPER'.AD12_SHIPERNAME,'"+replace(b,",","|")+"'))")}