View Issue Details

IDProjectCategoryView StatusLast Update
0003223OXID eShop (all versions)4.07. Source code, Testpublic2012-12-10 13:44
Reportertjungcl 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.2 revision 38481 
Target VersionFixed in Version4.6.0_beta2 
Summary0003223: oxarticle getVariantsIds returns ids unsorted
Descriptionoxarticle->_getVariantsIds() returns ids unsorted, although it makes no difference in performance.

so when you try to use the function for some purpose that is related to templates, you can not use it because of the wrong order.

=> adding "order by oxsort" has no practical impact on performance (tested 200 variants) but gives more flexibility in using _getVariantIds()

TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

related to 0003225 resolvedarvydas_vapsva reviews visible from inactive variants 

Activities

svetlana

2011-09-14 15:28

reporter   ~0005210

@developers please investigate it

vilma_liorensaityte

2011-09-15 09:08

manager   ~0005214

We will add sorting, but as actually "order by" impacts performance, we need to add one more index to oxarticle table:

ALTER TABLE `oxarticles` ADD INDEX `parentsort` ( `OXPARENTID` , `OXSORT` )