|
最佳回答 |
|
0
|
CD20160914Lv8专家互助发布于2024-12-2 15:07
|
sql("FRDemo","select distinct dept_id,dept_name,dept_desc from user where 1=1"+ IF($fine_username = "admin"||$fine_username = "郑二"||$fine_username = "彭三","","AND user_name = '"+$fine_username+"'") +"and object_type = '"+$object_type+"' and object_name = '"+$object_name+"' order by dept_desc ",1,1) |
|
|
|
|
最佳回答 |
|
0
|
用户k6280494Lv6资深互助发布于2024-12-2 15:05（编辑于 2024-12-2 15:08）
|
SQL函数 sql("FRDemo","select distinct dept_id,dept_name,dept_desc from user where 1=1" + IF(fine_username = 'admin'|| fine_username = '郑二' || fine_username = '彭三',"","AND user_name = '"+$fine_username+"' and object_type = '"+$object_type+"' and object_name = '"+$object_name+"' order by dept_desc "),1,1) |
|
|
|
|
最佳回答 |
|
0
|
snrtuemcLv8专家互助发布于2024-12-2 15:08
|
sql("FRDemo","select distinct dept_id,dept_name,dept_desc from user where 1=1"+IF(fine_username = 'admin'||fine_username = '郑二'||fine_username = '彭三',"","AND user_name = '"+$fine_username+"' and object_type = '"+$object_type+"' and object_name = '"+$object_name+"' order by dept_desc ",1,1) |
|
|
|
|
最佳回答 |
|
0
|
俊凯-王Lv5见习互助发布于2024-12-2 21:09
|
sql("FRDemo","select distinct dept_id,dept_name,dept_desc from user where 1=1"+ if($fine_username="admin"||$fine_username="郑二"||$fine_username="彭三","",""and user_name='"+$fine_username+"')+" and object_type='"+$object_type+"'and object_name='"+$object_name+"' order by depet_desc",1,1) |
|
|
|
1min目标场景问卷
立即参与
