How to load a custom attibute to a product collection in the flat mode?

qvv · April 14, 2016, 8:55am

Hi guys,
I have a custom product attribute with code is_hot.
How to filter the Product Collection with this attribute in case the Catalog Product Flat Mode is enabled (http://i.imgur.com/xm45pqi.png)?
Thanks for help.

dmitrii_fediuk · April 14, 2016, 9:00am

Enable the «Used in Product Listing» option for the attribute.

Delete the cache.
Rebuild the indices. The attribute will be added to the flat product table, and will be loaded to the product collections.
Load the collection.
Filter the collection by the standard ways.

qvv · April 14, 2016, 9:26am

@dmitry_fedyuk: Thanks for your reply It helps me.