{"id":1259,"date":"2024-03-15T19:05:21","date_gmt":"2024-03-15T13:35:21","guid":{"rendered":"https:\/\/magecurious.com\/blog\/?p=1259"},"modified":"2025-01-11T22:59:44","modified_gmt":"2025-01-11T17:29:44","slug":"how-to-add-list-attribute-to-filter-condition-in-magento-2","status":"publish","type":"post","link":"https:\/\/magecurious.com\/blog\/how-to-add-list-attribute-to-filter-condition-in-magento-2\/","title":{"rendered":"How To Add List Attribute To Filter Condition In Magento 2"},"content":{"rendered":"\n

Hello Everyone,<\/p>\n\n\n\n

In this blog, we will learn about addAttributeToFilter Condition in Magento 2. <\/p>\n\n\n\n

In Magento there are many conditions to filter collection using addAttributeToFilter or addFieldToFilter function.<\/p>\n\n\n\n

addAttributeToFilter add WHERE condition in Mysql query.<\/p>\n\n\n\n

Without wasting your time, let us guide you straight away. Below is a list of addAttributeToFilter Conditions in Magento 2.<\/p>\n\n\n\n

LIST OF <\/strong>addAttributeToFilter<\/strong> CONDITION IN MAGENTO 2<\/strong><\/p>\n\n\n\n

Condition<\/strong><\/td>Syntex<\/strong><\/td>Example<\/strong><\/td><\/tr>
Equals<\/td>eq<\/td>$collection->addAttributeToFilter(‘status’, array(‘eq’ => 1));<\/td><\/tr>
Not Equals<\/td>neq<\/td>$collection->addAttributeToFilter(‘sku’, array(‘neq’ => ‘test-product’));<\/td><\/tr>
Like<\/td>like<\/td>$collection->addAttributeToFilter(‘sku’, array(‘like’ => ‘UX%’));<\/td><\/tr>
Not Like<\/td>nlike<\/td>$collection->addAttributeToFilter(‘sku’, array(‘nlike’ => ‘err-prod%’));<\/td><\/tr>
In<\/td>in<\/td>$collection->addAttributeToFilter(‘id’, array(‘in’ => array(1,3,5)));<\/td><\/tr>
Not In<\/td>nin<\/td>$collection->addAttributeToFilter(‘id’, array(‘nin’ => array(1,3,5)));<\/td><\/tr>
NULL<\/td>null<\/td>$collection->addAttributeToFilter(‘description’, array(‘null’ => true));<\/td><\/tr>
Not NULL<\/td>notnull<\/td>$collection->addAttributeToFilter(‘description’, array(‘notnull’ => true));<\/td><\/tr>
Greater Than<\/td>gt<\/td>$collection->addAttributeToFilter(‘id’, array(‘gt’ => 3));<\/td><\/tr>
Less Than<\/td>lt<\/td>$collection->addAttributeToFilter(‘id’, array(‘lt’ => 5));<\/td><\/tr>
Greater Than or Equals To<\/td>gteq<\/td>$collection->addAttributeToFilter(‘id’, array(‘gteq’ => 10));<\/td><\/tr>
Less Than or Equals To<\/td>lteq<\/td>$collection->addAttributeToFilter(‘id’, array(‘lteq’ => 7));<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

Final Thoughts:<\/strong><\/p>\n\n\n\n

So this was the easiest way which we have told you in this blog. This is a List of Conditions which can be used with addAttributeToFilter  in Magento 2. Hope you liked the blog.<\/p>\n\n\n\n

So quickly go to the comment box and tell me how you like this blog?<\/p>\n\n\n\n

Stay tuned with us on our site to get new updates of Magento.<\/strong><\/p>\n\n\n\n

Thanks for reading and visiting our site.<\/p>\n\n\n

How useful was this post? <\/p>

Click on a star to rate it! <\/p>

  • <\/i> <\/li>
  • <\/i> <\/li>
  • <\/i> <\/li>
  • <\/i> <\/li>
  • <\/i> <\/li> <\/ul> <\/div>

    <\/p>