details: https://code.openbravo.com/erp/devel/pi/rev/4eae47894e32
changeset: 35513:4eae47894e32
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Mar 05 19:04:20 2019 +0530
summary: Fixes Issue 0040284: Manage pre-reservation not possible
** Do not use strict join on storage bin in query used to
get selected lines to avoid skipping of reservation stock
(pre-reservation) as they do not have storage bins, hence
used left join in place.
diffstat:
src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
| 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 461aa8d25eb6 -r 4eae47894e32
src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
---
a/src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
Thu Feb 28 11:24:05 2019 +0530
+++
b/src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
Tue Mar 05 19:04:20 2019 +0530
@@ -11,7 +11,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2014-2018 Openbravo SLU
+ * All portions are Copyright (C) 2014-2019 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -954,7 +954,7 @@
final StringBuilder hqlString = new StringBuilder();
hqlString.append("select rs from MaterialMgmtReservationStock rs ");
hqlString.append(" join rs.reservation as r");
- hqlString.append(" join rs.storageBin as sb");
+ hqlString.append(" left join rs.storageBin as sb");
hqlString.append(" where rs.reservation = :reservation ");
if (reservation.getAttributeSetValue() != null) {
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
