过滤器表达这么写:((#CSVIdentityNameList('')# contains 'bimanager' and 'bisupervisor') ) or( (#CSVIdentityNameList('')# not contains 'bimanager' and 'bisupervisor') and (roleValue('_shortName',[Critical Sta...
if(?aa? is not null)then([条数] in ?aa?)else([SQL1].[CERTID]=?ff?)这个就是过滤器里写的,但是一直报in附近有错误:UDA-SQL-0358 行 27:“in”附近出现语法错误。RQP-DEF-0177 执行操作“sqlPrepareWithOptions”(状态为“-16”)时出错。UDA-SQL-0358 行 27:“in”附近出现...(more)
1. partition select c1,c2,c3, rank() over(partition by c2 order by c3 desc) as r1, rank() over (order by c3 desc) as r2 from t1 where c2 in (15,20) order by c2,c1  ...(more)