View Issue Details

IDProjectCategoryView StatusLast Update
0001285OXID eShop (all versions)3.1. Design, GUI, UXpublic2009-09-30 10:33
Reporterdainius.bigelis Assigned To 
Status resolvedResolutionno change required 
Product Version4.1.6 revision 22740 
Summary0001285: Two similar querries are used in getActiveSnippet
DescriptionNoticed that oxArticle::getActiveSnippet() uses 2 subqueries (!).
Please check is it really necesarry to do that way (maybe these are duplicated).
Additional InformationEntry moved from comments in the bug 0000626.
TagsNo tags attached.
PHP Version5.2.6
Database Version5.0.33



2009-09-30 10:33

reporter   ~0001848

oxArticle::getActiveSnippet() function was changed to oxArticle::getSqlActiveSnippet().

In this function both subqueries will be used:
1) first subquery is used to check if article has any active variants. With bug 0000932 some improvement were made: run this subquery only if varcount is not 0.
2) second subquery is used to check if this article has any rights.