StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQL Query collection in Magento
text
Body
copied!<p>I have this query:</p> <pre><code> $collection = $this->getAssociatedProductCollection($product) ->addAttributeToSelect('*') ->addFilterByRequiredOptions() ->setPositionOrder() ->addStoreFilter($this->getStoreFilter($product)) ->addAttributeToFilter('status', array('in' => $this->getStatusFilters($product))) ->addAttributeToSort('my_attribute', 'DESC'); </code></pre> <p>and I want to ORDER the associated products by "my_attribute"</p> <p>The snippet <code>->addAttributeToSort('my_attribute', 'DESC');</code> don't give me the good result because I have numbers stored as text in my atribute.</p> <p>I have make a test database and I have seen that current query make the good order in my test database: </p> <pre><code>SELECT * FROM length ORDER BY my_attribute + 0 </code></pre> <p>My question is: how to add the "+ 0" in my first Magento query to make the good order by :)</p> <p><strong>[EDIT]</strong></p> <p>Here is my complete modified function : </p> <pre><code>public function getAssociatedProducts($product = null) { if (!$this->getProduct($product)->hasData($this->_keyAssociatedProducts)) { $associatedProducts = array(); if (!Mage::app()->getStore()->isAdmin()) { $this->setSaleableStatus($product); } $collection = $this->getAssociatedProductCollection($product) ->addAttributeToSelect('*') ->addFilterByRequiredOptions() ->setPositionOrder() ->addStoreFilter($this->getStoreFilter($product)) ->addAttributeToFilter('status', array('in' => $this->getStatusFilters($product))) ->addAttributeToSort('breite', 'ASC') // My Modification ->addAttributeToSort('my_attribute', 'ASC'); // My Modification foreach ($collection as $item) { $associatedProducts[] = $item; } $this->getProduct($product)->setData($this->_keyAssociatedProducts, $associatedProducts); } return $this->getProduct($product)->getData($this->_keyAssociatedProducts); } </code></pre> <p><strong>[/EDIT]</strong></p> <p>Thanks a lot. :)</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload