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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040714
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POSmajorhave not tried2019-04-10 12:472019-05-02 08:31
ReportershuehnerView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR19Q2
StatusclosedFix in branchFixed in SCM revision82f52629670c
ProjectionnoneETAnoneTarget VersionRR19Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040714: POSUtils.getPriceListVersionForPriceList is not using bind-parameters

DescriptionThis code is not using bind-params:

      Query<PriceListVersion> priceListVersionQuery = OBDal.getInstance()
          .getSession()
          .createQuery("from PricingPriceListVersion AS plv " + "where plv.priceList.id ='"
              + priceListId
              + "' and plv.active=true and plv.validFromDate = (select max(pplv.validFromDate) "
              + "from PricingPriceListVersion as pplv where pplv.active=true and pplv.priceList.id = '"
              + priceListId + "' and to_char(pplv.validFromDate,'yyyy-mm-dd') <= '"
              + format.format(terminalDate) + "' )", PriceListVersion.class);
      for (PriceListVersion plv : priceListVersionQuery.list()) {
        return plv;
      }
Steps To Reproduce-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0040583 closedranjith_qualiantech_com POSUtils.getPriceListVersionForPriceList is not using bind-parameters 

-  Notes
(0111414)
hgbot (developer)
2019-05-02 08:22

Repository: retail/backports/3.0RR19Q2/org.openbravo.retail.posterminal
Changeset: 82f52629670cd0ad1a6f37869a82d69afb270509
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu May 02 11:52:10 2019 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR19Q2/org.openbravo.retail.posterminal/rev/82f52629670cd0ad1a6f37869a82d69afb270509 [^]

Fixed issue 40714 : Update POSUtils query to use query parameter

---
M src/org/openbravo/retail/posterminal/POSUtils.java
---

- Issue History
Date Modified Username Field Change
2019-04-30 11:53 shuehner Type defect => backport
2019-04-30 11:53 shuehner Target Version => RR19Q2
2019-05-02 08:22 hgbot Checkin
2019-05-02 08:22 hgbot Note Added: 0111414
2019-05-02 08:22 hgbot Status scheduled => resolved
2019-05-02 08:22 hgbot Resolution open => fixed
2019-05-02 08:22 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c82334b59fdf53cb9b49284e8ff3a939c5c46d03 [^] => http://code.openbravo.com/retail/backports/3.0RR19Q2/org.openbravo.retail.posterminal/rev/82f52629670cd0ad1a6f37869a82d69afb270509 [^]
2019-05-02 08:31 marvintm Review Assigned To adrianromero => marvintm
2019-05-02 08:31 marvintm Status resolved => closed
2019-05-02 08:31 marvintm Fixed in Version => RR19Q2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker