Search Results

To make it correct, you derive a custom collection from the standard one. … If models write to the database, they have a resource model and a collection class. this is defined via the <resourceModel> node. …

Then you can get the select from the collection and put the one in the other. … $subquery = Mage::getSingleton('core/resource')->getConnection('core_write');->select() $collection->getSelect()->where("myAttribute = $subquery") // example more: https://stackoverflow.com/questions …

->addUrlRewrite($subcategory->getId()) This loads the collection, everything after this doesn't do anything about the sql query. …

Works $collection = Mage::getResourceModel('catalog/product_collection'); Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection); Mage::getSingleton('catalog … /product_visibility')->addVisibleInCatalogFilterToCollection($collection); $collection->addMinimalPrice() ->addFinalPrice() ->addTaxPercents() ->addAttributeToSelect(Mage:: …

Collection itself As Minesh pointed out indirectly: There is no way using the API of the colletion directly. … The problem is, that magento only implements IteratorAggregate, so the Collection itself doesn't offer what you want. …

And group name, like this: $collection->joinTable('customer/customer_group', 'customer_group_id=group_id', array('customer_group_code'), null, 'left'); Didn't tested it ;-) It is important to set as …

After loading, all the items are added to the collection, if an order id is already set, this error is thrown. What do you want to achieve? …

count() loads the collection, therefore it doesn't matter to reload it. … /lib/Varien/Data/Collection/Db.php:208 /** * Get collection size * * @return int */ public function getSize() { if (is_null($this->_totalRecords)) { $sql = $this->getSelectCountSql(); …

/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php:339 /** * Wrapper for compatibility with Varien_Data_Collection_Db * * @param mixed $attribute * @param mixed $condition */ public function … Load the collection and then check echo (string)$collection->getSelect(). After(!) the ->load(). …

Because count() calls $collection->count() which does: \Varien_Data_Collection::count public function count() { $this->load(); return count($this->_items); } and after the collection is loaded … So remove the if(count($collection) > 0) and everything is fine :-) Or instead use getSize() which does not load the collection: \Varien_Data_Collection_Db::getSize public function getSize() { if …

Did you try: $select = $collection1->getSelect()->union($collection2->getSelect());

You can change the collection to use the protected $_filters = array(); property instead of applying the filters directly, then you can just get the filter, if you have access to this property. …

You can use $collection->getTable('catalog/product') to get a table name, including prefix and everything The information which size the customer chose is encoded in product_options and there is no easy …

I think the only alternative is to join catalog_category_product into the product collection …

Both methods load the collection and count the items. UPDATE Oh I see a problem: getSize() caches the _totalRecords, this means it is not recalculated. Check where _totalRecords is set? …