这个写得有错吗 - 我的帆软

这个写得有错吗

sql("数据连接1",

" SELECT

字段1,

字段2

FROM

table_name

where

1=1"

+if(org1 == 'teat',"","and Z_NAME = '" + org1 + "'")

+if(INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1) == 0000,"",if(find('Z',INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1))>0,"and ID1 = '" + INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1) + "'","and ID2 = '" + INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1) + "'"))+"order by case when 字段1 is null then 0

else 字段1"",2,1)

FineReport 123木头人1 发布于 2024-10-8 14:53

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

华莉星宸Lv7资深互助
发布于2024-10-8 14:56

sql("数据连接1","SELECT 字段1,字段2 FROM table_name where 1=1"+if(org1 == 'teat',"","and Z_NAME = '" + org1 + "'")+if(INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1) == '0000',"",if(find('Z',INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1))>0,"and ID1 = '" + INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1) + "'","and ID2 = '" + INDEXOFARRAY(REVERSEARRAY(split(array1,",")),1) + "'"))+"order by case when 字段1 is null then 0 else 字段1",2,1)