SELECT * FROM 销量 where 1=1

${if(fine_username=="admin"||fine_username=="admin1",""," and 英文简称='"+fine_username+"'")}

这个格式去设置

where后面判断if(特例用户，"","英文简称='+fine_username+'")

SELECT * FROM 销量 where 1=1

${if(fr_username='admin',"","英文简称='"+fine_username+"'")}

首先把能某些用户放到一个表格里面，一般把这类用户定义为某一类 角色，根据登陆的账号判断这个账号的角色，来自由拼sql

如下，角色超级管理员不控制，角色为其它自定义可查看所有数据的也不控制，否则只看自己相关的数据

${if(fine_role="superusers","",if(sql("dcresult","select count(fr_roles_id) from dim_user_roles ro where ro.fr_roles_id=1 and ro.user_fr_name='"+fine_username+"'",1,1)<>0," "," and t.employees_id in (select ro.employ_id from dim_user_roles ro where  ro.user_fr_name='"+fine_username+"')"))}