Timeline for Wrong sorting with "name" attribute
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 12, 2017 at 8:39 | history | bounty ended | René Höhle | ||
| May 11, 2017 at 21:16 | history | edited | sv3n | CC BY-SA 3.0 |
added 80 characters in body
|
| May 11, 2017 at 20:42 | vote | accept | René Höhle | ||
| May 11, 2017 at 19:44 | comment | added | sv3n | Let us continue this discussion in chat. | |
| May 11, 2017 at 19:37 | comment | added | sv3n | Possible that it is related to an 3rd-party-extension? | |
| May 11, 2017 at 19:18 | comment | added | René Höhle |
It's the original code without any modifications and yes there is only salable in the Order by statement and not the name. When i add the line to sort i get an error: You cannot define a correlation name 'stock_qty' more than once very strange.
|
|
| May 11, 2017 at 19:15 | comment | added | sv3n |
And it is still saleable instead of name? (Without $this->_productCollection->addAttributeToSort("name");?
|
|
| May 11, 2017 at 19:13 | comment | added | René Höhle | I've done that. To test it again. | |
| May 11, 2017 at 19:11 | comment | added | sv3n | I know :) Therefore you should put your debug code in getCollection() - not in setCollection() - method (and maybe post your query here) . | |
| May 11, 2017 at 19:09 | comment | added | René Höhle |
Thx for your suggestion. I've done that in the Toolbar.php that i've written on top. There is not order by. ORDER BY salable` DESC, qty DESC LIMIT 10` that is the only order but salelable is not correct. Name is selected in my sorting filter.
|
|
| May 11, 2017 at 15:42 | history | answered | sv3n | CC BY-SA 3.0 |