In MySQL, this works:
and (
account.type in (‘affiliate’, ‘customer’, ‘trial’, ‘dupe’, ‘promo’)
or account.type is null
)
but I’m unable to figure out how to use ‘null’ in a filter with other text fields. Any ideas?
In MySQL, this works:
and (
account.type in (‘affiliate’, ‘customer’, ‘trial’, ‘dupe’, ‘promo’)
or account.type is null
)
but I’m unable to figure out how to use ‘null’ in a filter with other text fields. Any ideas?