Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031804Retail ModulesWeb POSpublic2015-11-21 16:172016-02-16 17:01
ReporterOrekaria 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q2Fixed in Version 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031804: Stabilization: Explicitly sort the search product results
DescriptionStabilization: Explicitly sort the search product results
Steps To ReproduceVerify that the 'ProductCharacteristicsSearchProductChangesCharacteristic_HV' is sometimes failing

See related issue 31554
Proposed SolutionThis issue should be fixed changing in Product.java this line:
 hql += "order by pli.product.name";
change with:
 hql += "order by pli.product.name asc";

There are also 2 queries more in Product.java that should have the order by.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0031554RR16Q1 closed Orekaria Stabilization: Explicitly sort the search product results 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-12-30 16:29OrekariaTypedefect => backport
2015-12-30 16:29OrekariaTarget Version => RR16Q2
2015-12-30 16:30OrekariaProposed Solution updated
2015-12-30 16:31OrekariaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10569#r10569
2015-12-30 16:31OrekariaProposed Solution updated
2015-12-30 16:31OrekariaStatusscheduled => acknowledged
2016-01-11 06:53ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2016-01-11 06:53ranjith_qualiantech_comStatusacknowledged => scheduled
2016-01-12 18:21gorka_gilNote Added: 0083213
2016-01-12 18:21gorka_gilStatusscheduled => resolved
2016-01-12 18:21gorka_gilResolutionopen => fixed
2016-01-12 18:21gorka_gilFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/100c2bc635df541c79b78d9f9f123630ea2bf786 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/acd438a5a2d3e360006f7acf5d96849e551aa7ec [^]
2016-01-12 18:21gorka_gilNote Added: 0083214
2016-02-16 17:01migueldejuanaNote Added: 0084266
2016-02-16 17:01migueldejuanaStatusresolved => closed

Notes
(0083213)
gorka_gil   
2016-01-12 18:21   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: acd438a5a2d3e360006f7acf5d96849e551aa7ec
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jan 12 15:54:37 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/acd438a5a2d3e360006f7acf5d96849e551aa7ec [^] [^]

Fixes issue 31804 : Stabilization in Terminal Master Product

Adding Order by clause in Product, Characteristics

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0083214)
gorka_gil   
2016-01-12 18:21   
Repository: tools/automation/pi-mobile
Changeset: fe4a10ed246d8be9d8ea2d54675d051304b6e72a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jan 12 15:53:21 2016 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/fe4a10ed246d8be9d8ea2d54675d051304b6e72a [^] [^]

Verifies issue 31804: Added automated test 'I31804_CheckProductOrderWhileSearch'

---
M src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31804_CheckProductOrderWhileSearch.java
---
(0084266)
migueldejuana   
2016-02-16 17:01   
Tested and reviewed in bf5683b09d0a