Error message changes for boolean comparisons in table calculations (3.46+)

(Joshua Moskovitz) #1

A bug in our table calculation code incorrectly allowed for comparisons between mismatched field types, causing errors. As a side effect, however, comparing booleans YesNo’s to strings “Yes”/”No” will no longer work.

For example beginning in 3.46 this table calculations syntax is_null(${orders.count}) = "yes"

will result in the following error message:

Instead, please use this syntax:

is_null(${orders.count}) which will return a boolean (YesNo) field.

If you have any questions or need assistance in updating please let us know, we are happy to help. We apologize for any inconvenience.

Looker 3.46 Release Notes