Mfrhtyj

When I use addAttributeToFilter on MagentoCatalogModelResourceModelProductCollectionFactory, with a custom attribute, I always get 0 results.

use MagentoCatalogModelResourceModelProductCollectionFactory;

use MagentoCatalogModelProductRepository;

use MagentoFrameworkApiSearchCriteriaBuilder;



...



$collection = $this->productCollection->create()

            ->addAttributeToSelect(array('custom_attribute','sku'))

            ->addAttributeToFilter('custom_attribute',['lt' => 1]);

        }



echo count($collection); //Returns 0

I also tried to use the search criteria object as Konrad Siamro sugested:

$search_criteria = $this->searchCriteriaBuilder

                ->addFilter('custom_attribute', 1, 'lt')

                ->create();

            $collection = $this->productRepository->getList($search_criteria);



echo $collection->getTotalCount(); //returns 0

But the results are the same. It works fine if I filter on a SKU, but my custom attribute returns nothing. I also tried adding the attribute to the flat product database and re indexing.

Update: Added code I used to create the attribute:

$eavSetup->addAttribute(

        MagentoCatalogModelProduct::ENTITY,

        'custom_attribute',

        [

            'type' => 'int',

            'backend' => '',

            'frontend' => '',

            'frontend_class' => 'validate-digits',

            'label' => 'Custom Attribute',

            'input' => 'text',

            'class' => 'class',

            'source' => '',

            'global' => MagentoEavModelEntityAttributeScopedAttributeInterface::SCOPE_GLOBAL,

            'visible' => true,

            'required' => false,

            'user_defined' => false,

            'default' => '',

            'searchable' => false,

            'filterable' => false,

            'comparable' => false,

            'visible_on_front' => true,

            'used_in_product_listing' => true,

            'unique' => false,

            'apply_to' => ''

        ]

    );

Use search criteria for filtering collections.

Go to http://alanstorm.com/magento_2_understanding_object_repositories/

and look for search criteria.

Problem is that when you create your custom_attribute its still empty:

'user_defined' => false,

        'default' => '',

        'searchable' => false,

your default value is empty, but you check if value is lower than 1

->addFilter('custom_attribute', 1, 'lt')

I tested it and result without setting any value for the custom_attribute gave as result 0 items which is the correct result. I changed for example the filter to

->addFilter('custom_attribute', 1, 'eq')

and set the custom_attribue to 1 in one Product in Admin. Result is now one.

Problem is lower than one is not "empty"

Tried it with the searchCriteriaBuilder and with addAttributeToFilter works both with changed Filters and setting the custom_attribute for example to 1.