NotNull not working with AddFieldToFilter in Magento 2

Question

I have following code to filter out rows on a column that is null and it is working

->addFieldToFilter(
            'ep_image',
            ['null' => true]
       )

and I have another code to filter out rows on a column that is not null which is not working

->addFieldToFilter(
            'ep_image',
            ['notnull' => true]
       )

Can anyone help me out on how to filter not null values?

Also tried array('notnull' => true)and array('null' => false), but none working.

Priyank · Accepted Answer · 2017-02-10 09:04:16Z

28

You can try this

->addFieldToFilter(
            'ep_image',
            ['neq' => 'NULL']
       )

answered Feb 10, 2017 at 9:04

Priyank

7,7427 gold badges38 silver badges70 bronze badges

2

Thanks @userpk, that worked!!! Above code mentioned by me also worked, the issue was due to same variable being used by two different code.
– Nausif
Commented Feb 10, 2017 at 9:16

Add a comment |

Wasim · Accepted Answer · 2021-07-23 11:31:21Z

2

The followings work for me correctly:

//IS NULL

->addFieldToFilter(
 'ep_image',
 array('null' => true)

//IS NOT NULL

->addFieldToFilter(
 'ep_image',
 array('notnull' => true)

answered Jul 23, 2021 at 11:31

Wasim

4554 silver badges18 bronze badges

Add a comment |

2 Answers 2