Magento 2 - Custom Attribute Filter - addFieldToFilter

Question

I'm trying to filter products by a custom attribute, but the addFieldToFilter isn't working. I get an error "Error filtering template: Warning: Illegal string offset 'attribute'"

Where am I going wrong?

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection');
$productCollection->addFieldToFilter(
                           array('attribute'=>'engine_store_show_on_homepage','eq'=>1)
                       );
$productCollection->load();
echo "<pre>";print_r($productCollection->getData()); //print product collection

I appreciate others have asked the same question, but I don't understand the answers given as they all require a class or module to be created. I'm trying to do this within a template .phtml file.

Answer 1

Hi @chirs use below code for the filter. use addAttributeToFilter Instead of addFieldToFilter

$collection->addAttributeToFilter('engine_store_show_on_homepage', ['eq' => 1]);

Answer 2

You Get Filter Following code :-

$_products->addAttributeToFilter('engine_store_show_on_homepage', array('eq' => 1)); // Using the operator
$_products->addAttributeToFilter('engine_store_show_on_homepage', 1); // Without using the operator

And check more information :-

https://fishpig.co.uk/magento/tutorials/addattributetofilter/

THANKS.