NULL Value Qualifying for Smart List Filter With Less Than Operator
Issue
Issue Description
A Smart List with a filter for an integer field with a specified range value, such as 'less than 100', is qualifying records that have a NULL(empty) value for the integer field.
A Smart List with a filter for an integer field with a specified range value, such as 'less than 100', is qualifying records that have a NULL(empty) value for the integer field.
Solution
Issue Resolution
Marketo will treat NULL/empty as equivalent to 0 in this case, and qualify the lead as having a value less than 100. However, Marketo does not treat 0 as NULL/empty
Adding the filter "[field] is not empty" to block records with NULL values will resolve this