Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032551
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2016-03-29 17:482016-04-28 09:27
ReporterSandrahuguetView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in VersionRR16Q2
StatusclosedFix in branchFixed in SCM revision9134fc6e1533
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customerNo
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
Summary

0032551: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0031257RR16Q2 closedSandrahuguet Prevent sql injection in SimpleQueryBuilder 
depends on backport 0032139RR16Q1 closedSandrahuguet Prevent sql injection in SimpleQueryBuilder 
depends on backport 0032552RR16Q1.1 closedSandrahuguet Filter by stockcriteria and pricecriteria in the same query does not work 

-  Notes
(0085322)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (viewer)
2016-03-31 11:48

 Reviewed and tested
(0086042)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2016-03-29 17:48 Sandrahuguet New Issue
2016-03-29 17:48 Sandrahuguet Assigned To => Sandrahuguet
2016-03-29 17:48 Sandrahuguet OBNetwork customer => No
2016-03-29 17:48 Sandrahuguet Regression level => Production - QA Approved
2016-03-29 17:48 Sandrahuguet Regression date => 2016-03-07
2016-03-29 17:48 Sandrahuguet Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0e9112f9a67603cbdffe1e5c4aba3b6aabdaa41e [^]
2016-03-29 17:48 Sandrahuguet Triggers an Emergency Pack => No
2016-03-29 17:49 Sandrahuguet Relationship added related to 0032521
2016-03-29 17:49 Sandrahuguet Relationship deleted related to 0032521
2016-03-29 17:49 Sandrahuguet Relationship added depends on 0031257
2016-03-29 17:49 Sandrahuguet Relationship added depends on 0032139
2016-03-29 17:50 Sandrahuguet Status new => scheduled
2016-03-29 17:50 Sandrahuguet Regression introduced in release => RR16Q1
2016-03-29 18:20 Sandrahuguet Steps to Reproduce Updated View Revisions
2016-03-29 18:20 Sandrahuguet Steps to Reproduce Updated View Revisions
2016-03-29 18:21 Sandrahuguet Steps to Reproduce Updated View Revisions
2016-03-29 18:21 Sandrahuguet Review Assigned To => mtaal
2016-03-30 08:54 hgbot Checkin
2016-03-30 08:54 hgbot Note Added: 0085322
2016-03-30 08:54 hgbot Status scheduled => resolved
2016-03-30 08:54 hgbot Resolution open => fixed
2016-03-30 08:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/9134fc6e15333ebdedc91231f0df73b16463b17b [^]
2016-03-30 08:58 hgbot Checkin
2016-03-30 08:58 hgbot Note Added: 0085323
2016-03-30 09:03 hgbot Checkin
2016-03-30 09:03 hgbot Note Added: 0085324
2016-03-31 09:25 hgbot Checkin
2016-03-31 09:25 hgbot Note Added: 0085345
2016-03-31 11:47 hgbot Checkin
2016-03-31 11:47 hgbot Note Added: 0085352
2016-03-31 11:48 mtaal Note Added: 0085353
2016-03-31 11:48 mtaal Status resolved => closed
2016-03-31 11:48 mtaal Fixed in Version => RR16Q2
2016-04-28 09:27 hgbot Checkin
2016-04-28 09:27 hgbot Note Added: 0086042

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker