Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032551Retail ModulesWeb POSpublic2016-03-29 17:482016-04-28 09:27
ReporterSandrahuguet 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in VersionRR16Q2 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression levelProduction - QA Approved
Regression date2016-03-07
Regression introduced in releaseRR16Q1
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0e9112f9a67603cbdffe1e5c4aba3b6aabdaa41e [^]
Triggers an Emergency PackNo
Summary0032551: Filter by stockcriteria and pricecriteria in the same query does not work
DescriptionFilter by stockcriteria and pricecriteria in the same query does not work in remote and in normal mode.
Steps To Reproduce-Log in Openbravo as system administrator and install "Filter by price in product search" and "Filter by stock in product search" modules.
-Log in the WebPOS
-Tap stock criteria button and filter by: "More than, 0"
-Tap price criteria button and filter by: "More than, 0"
-Notice that OBDAL error is shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0031257RR16Q2 closed Sandrahuguet Prevent sql injection in SimpleQueryBuilder 
depends on backport 0032139RR16Q1 closed Sandrahuguet Prevent sql injection in SimpleQueryBuilder 
depends on backport 0032552RR16Q1.1 closed Sandrahuguet Filter by stockcriteria and pricecriteria in the same query does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-03-29 17:48SandrahuguetNew Issue
2016-03-29 17:48SandrahuguetAssigned To => Sandrahuguet
2016-03-29 17:48SandrahuguetRegression level => Production - QA Approved
2016-03-29 17:48SandrahuguetRegression date => 2016-03-07
2016-03-29 17:48SandrahuguetRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0e9112f9a67603cbdffe1e5c4aba3b6aabdaa41e [^]
2016-03-29 17:48SandrahuguetTriggers an Emergency Pack => No
2016-03-29 17:49SandrahuguetRelationship addedrelated to 0032521
2016-03-29 17:49SandrahuguetRelationship deletedrelated to 0032521
2016-03-29 17:49SandrahuguetRelationship addeddepends on 0031257
2016-03-29 17:49SandrahuguetRelationship addeddepends on 0032139
2016-03-29 17:50SandrahuguetStatusnew => scheduled
2016-03-29 17:50SandrahuguetRegression introduced in release => RR16Q1
2016-03-29 18:20SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11550#r11550
2016-03-29 18:20SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11551#r11551
2016-03-29 18:21SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11552#r11552
2016-03-29 18:21SandrahuguetReview Assigned To => mtaal
2016-03-30 08:54hgbotCheckin
2016-03-30 08:54hgbotNote Added: 0085322
2016-03-30 08:54hgbotStatusscheduled => resolved
2016-03-30 08:54hgbotResolutionopen => fixed
2016-03-30 08:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/9134fc6e15333ebdedc91231f0df73b16463b17b [^]
2016-03-30 08:58hgbotCheckin
2016-03-30 08:58hgbotNote Added: 0085323
2016-03-30 09:03hgbotCheckin
2016-03-30 09:03hgbotNote Added: 0085324
2016-03-31 09:25hgbotCheckin
2016-03-31 09:25hgbotNote Added: 0085345
2016-03-31 11:47hgbotCheckin
2016-03-31 11:47hgbotNote Added: 0085352
2016-03-31 11:48mtaalNote Added: 0085353
2016-03-31 11:48mtaalStatusresolved => closed
2016-03-31 11:48mtaalFixed in Version => RR16Q2
2016-04-28 09:27hgbotCheckin
2016-04-28 09:27hgbotNote Added: 0086042

Notes
(0085322)
hgbot   
2016-03-30 08:54   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 9134fc6e15333ebdedc91231f0df73b16463b17b
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Mar 30 08:53:33 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/9134fc6e15333ebdedc91231f0df73b16463b17b [^]

fixed issue 32551 manage properly some parenthesis in simplequerybuilder

---
M src/org/openbravo/mobile/core/process/SimpleQueryBuilder.java
---
(0085323)
hgbot   
2016-03-30 08:58   
Repository: erp/pmods/org.openbravo.retail.pricecriteria
Changeset: 0ca76b24ef7089838a7733dc3a9e45c159361d7e
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Mar 30 08:57:59 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.pricecriteria/rev/0ca76b24ef7089838a7733dc3a9e45c159361d7e [^]

related to issue 32551 manage properly some parenthesis in simplequerybuilder

---
M src/org/openbravo/retail/pricecriteria/PriceBrandHQLCriteria.java
M src/org/openbravo/retail/pricecriteria/PriceChHQLCriteria.java
M src/org/openbravo/retail/pricecriteria/PriceChValueHQLCriteria.java
M web/org.openbravo.retail.pricecriteria/js/hookPriceCriteria.js
---
(0085324)
hgbot   
2016-03-30 09:03   
Repository: erp/pmods/org.openbravo.retail.stockcriteria
Changeset: 32354a6b16da5b7d604d7da9f878bbf49932d42b
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Mar 30 09:03:35 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.stockcriteria/rev/32354a6b16da5b7d604d7da9f878bbf49932d42b [^]

related to issue 32551 manage properly some parenthesis in simplequerybuilder

---
M src/org/openbravo/retail/stockcriteria/BrandHQLCriteria.java
M src/org/openbravo/retail/stockcriteria/StockChHQLCriteria.java
M src/org/openbravo/retail/stockcriteria/StockChValueHQLCriteria.java
M web/org.openbravo.retail.stockcriteria/js/hookStockCriteria.js
---
(0085345)
hgbot   
2016-03-31 09:25   
Repository: tools/automation/pi-mobile
Changeset: d927ec1e098bd6f6452c39426eaebc74fe9e7243
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Mar 31 09:24:58 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/d927ec1e098bd6f6452c39426eaebc74fe9e7243 [^]

related to issue 32551 added I32551_FilterByStockAndPriceCriteria test

---
A src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/stockcriteria/I32551_FilterByStockAndPriceCriteria.java
---
(0085352)
hgbot   
2016-03-31 11:47   
Repository: tools/automation/pi-mobile
Changeset: d5d172d8eedd3fa9bed27c6584b5076ba81da2c9
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Mar 31 11:47:00 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/d5d172d8eedd3fa9bed27c6584b5076ba81da2c9 [^]

related to issue 32551 check the number of products in TABLE_SEARCHPRODUCTS

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/stockcriteria/I32551_FilterByStockAndPriceCriteria.java
---
(0085353)
mtaal   
2016-03-31 11:48   
Reviewed and tested
(0086042)
hgbot   
2016-04-28 09:27   
Repository: tools/automation/pi-mobile
Changeset: e848b515ddfd1cb3e90bd6c940fd28babcc2c84c
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Apr 28 09:26:50 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/e848b515ddfd1cb3e90bd6c940fd28babcc2c84c [^]

related to issue 32551 fixed test because fails in hgvol job

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/stockcriteria/I32551_FilterByStockAndPriceCriteria.java
---