Hi there,
I know I can use any function to check any element is null in an array like this:
any(fn!isnull, {0, null, 30}).
how to use any function to check if any element is 0?
Thank you.
Lin
Discussion posts and replies are publicly visible
Hi Lin,
You can try something like:
or({0,null, 30}=0)
OR
contains({0,null, 30},0)
You can you the contains() to just get true and false. You can also use whereContains to get the index of the element that is 0. There are many more methods to do this but really depends on your use case here.