Can you share the param value expression? I suspect it’s passing a tilde delimited list rather than one expected by t-sql IN clause. So your BAQ works for in(‘dept1’) but not for in(‘dept1~dept2’). If that’s the case, you can Convert to sql like so:
Can you share the param value expression? I suspect it’s passing a tilde delimited list rather than one expected by t-sql IN clause. So your BAQ works for in(‘dept1’) but not for in(‘dept1~dept2’). If that’s the case, you can Convert to sql like so: