How do I filter a collection by a YesNo type attribute?

Question

Hi All

I have a ‘featured’ attribute, which has a Yes/No select-list as the admin input. I presume that the values for Yes and No are 1 and 0, as they are for every other Yes/No list. However, if I try and filter a collection using the ‘featured’ attribute, it doesn’t work:

$feat_attribute = $_product->getResource()->getAttribute($featuredattribute)->getSource()->getOptionId(1);

But, if I make a ‘featured’ attribute with a dropdown, and write my own Yes and No, then it works as below:

$feat_attribute = $_product->getResource()->getAttribute($featuredattribute)->getSource()->getOptionId('Yes');

Anyone any ideas? I’ve also tried values as true/false, yes/no, on/off etc, but no joy.

Answer 1

Maybe you are supposed to use '1' and '0' instead of the integer-values?

Like:

$feat_attribute = $_product->getResource()->getAttribute($featuredattribute)->getSource()->getOptionId('1');

Answer 2

Whenever Magento's behavior is confusing me, I start hacking on the core source (a development copy, of course) to see what it's doing and why not doing what I think it should. I haven't done much playing around with the Admin UI stuff so I don't 100% understand your question, but take a look at the getOption function

File: /app/code/core/Mage/Eav/Model/Entity/Attribute/Source/Abstract.php

public function getOptionId($value)
{
    foreach ($this->getAllOptions() as $option) {
        if (strcasecmp($option['label'], $value)==0 || $option['value'] == $value) {
            return $option['value'];
        }
    }
    return null;
}

I'd add some Mage::Log and/or var_dump calls in there for the values of $option['label'] and $option['value'] and see why your comparison is failing.