problem with addAttributeToFilter

[elizondo82]

Hello all.
I try put a filter on the collection product.
So, I create 3 attrubute ancho,largo and ups.

I put this :
$_productCollection=Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter('ancho', array('eq'=>0));
//(The 0 is the id option)

There show me the result 0, but if I remove the line ->addFieldToFilter('ancho', array('eq'=>0)); there show me all products. also I put getAncho there show me the number.

On the Catalog>attributes I put all "Yes" show the result,search,frontend and etc...

What is the problem or some have a solution? The version from magento is 1.9.2
Thanks!!

[Sunil Patel]

Hello @elizondo82,

addFieldToFilter it should be addAttributeToFilter

[elizondo82]

Same result, show me nothing.

$_productCollection=Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter('ancho', array('eq'=>0));

[Sunil Patel]

Can I know that attribute type? Is that yes no type attribute or drop-down attribute?

[elizondo82]

Yes, the type is drop-down, first I put type text, but later I remove and I put drop-down. same name attributecode "ancho"

[Sunil Patel · Accepted solution]

Hello,
$sAttributeName = 'size';
$mOptionValue = 'medium';
$collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect('*')
->addFieldToFilter(
$sAttributeName,
array(
'eq' => Mage::getResourceModel('catalog/product')
->getAttribute($sAttributeName)
->getSource()
->getOptionId($mOptionValue)
)
);

If work then Mark as solution.

[elizondo82 · Accepted solution]

Thanks, is working.