When using

coalesce

on a custom rec I get "unsupported search". Is there some edge case where

coalesce

doesn't work?

Are you certain that the fields you have inside the

COALESCE

are all the same type?

You can not do coalesce with two different type of fields. COALESCE(field1,field2) will not work if field1 is integer and field2 is string for example