if判断如何实现如下对应逻辑

需求是如果登录者为21981和14433，那么proplist多选下拉框就算没选中点击查询也是默认查询电商客户，如果不是者两个账号，那么proplist多选下拉框就算没选中点击查询也是查询所有，现在这样有问题该如何解决如下Sql

"+if(len(propList)=0 &&$fr_username ="21981" && $fr_username ="14433",""," and cusattribute in ('"+replace(propList,",","','")+"')")+"

"+if(len(propList)=0 &&($fr_username ="21981" || $fr_username ="14433")," and cusattribute='电商客户'"," and cusattribute in ('"+replace(propList,",","','")+"')")+"

FineReport Q4512K41FF 发布于 2022-9-1 13:27 （编辑于 2022-9-1 13:28）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共3回答

最佳回答

weibwLv7高级互助
发布于2022-9-1 13:33

if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))