Magento addFieldToFilter allow NULLs

Question

When using the Magento collection method addFieldToFilter is it possible to allow filtering by NULL values? I want to select all the products in a collection that have a custom attribute even if no value is assigned to the attribute.

Answer 1

I see you already found a solution, but there is also this option:

$collection->addFieldToFilter('parent_item_id', array('null' => true));

But if you want to use "NULL" => false, which DOESN'T WORK. (and I noticed you can use elements such as "in", "nin", "eq", "neq", "gt"), you can do this:

$collection->addFieldToFilter('parent_item_id', array('neq' => 'NULL' ));

Hope this is still helpful...

Answer 2

This works for NOT NULL filters

$collection->addFieldToFilter('parent_item_id', array('notnull' => true));