Unable to locate func entry: coalesce

Junior Vidotti

I have a filter for active records, which can be null. In that case, it must return all records (active = true or false). If filter_active is set, then it shows me the results accordingly to filter_active.

To achieve that result, I use coalesce function like that:
[image.png](if filter_active is null, then record.active itself will be use to compare to record.active).

But I am getting this error when execute API call:

{"message":"Unable to locate func entry: coalesce"}

Junior Vidotti

Just managed to solve the problem, although I think the behavior above may be a bug.

The solution is even more elegant... 😁
[image.png]

Sean Montgomery

seems like a bug - we will check it out.

ignore empty values is very powerful!