Is there a way to do case when value in (null, 2, 3)? The null keeps causing everything to not return. I've also tried '', 2, 3. But whenever I add the null, or the '', it returns 0 results

case when {orderallocationstrategy.id} in (null, 2,3,4,5,-3) then 1 else 0 end

Try

case when NVL({orderallocationstrategy.id},0) in (0, 2,3,4,5,-3) then 1 else 0 end

thanks!