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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028545
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2015-01-08 17:122015-02-04 20:33
ReporterumartirenaView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version3.0PR15Q2
StatusclosedFix in branchFixed in SCM revisionc055bf42b4fc
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression levelPackaging and release
Regression date2014-12-22
Regression introduced in releasemain
Regression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87d [^]
Triggers an Emergency PackNo
Summary

0028545: Some filters in Grids built on HQL Based Table they don't work any more

DescriptionSome filters in Grids built on HQL Based Table they don't work any more. An error is shown in the log, i.e: ERROR org.openbravo.client.kernel.KernelUtils - could not resolve property: outstandingAmount of: FIN_Payment [select f.id, f.documentNo, f.description, f.paymentDate, f.generatedCredit - f.usedCredit as outstandingAmount, '0' as paymentAmount from FIN_Payment f where f.generatedCredit != '0' and f.generatedCredit != f.usedCredit and f.client.id in ('0', '4028E6C72959682B01295A070852010D') AND f.organization in ('357947E87C284935AD1D783CF6F099A1','0','43D590B4814049C6B85C6545E8264E37') AND ( f.outstandingAmount = :alias_0 ) and f.businessPartner.id = :bp and f.receipt = :issotrx ]
org.hibernate.QueryException: could not resolve property: outstandingAmount of:
Steps To ReproduceIn live.builds:
* Create a Sales Invoice for a Business partner. Add a line with a product and Complete it.
* Press on Add Payment and pay more than the Invoice Amount. Leave the Credit to be used later. Click Done.
* Create another Sales Invoice for the same Business Partner. Add a line with a product and Complete it.
* Press on Add Payment. See that Credit to Use grid is now displayed.
* Put a filter on Outstanding Amount column that should leave some record in the grid. See that No data is displayed.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by defect 00284323.0PR15Q1 closedAugustoMauch can't filter product FK drop down in return windows P&E 
related to defect 0028565 closedumartirena not possible to filter by LineNo field in Match LC Cost 

-  Notes
(0073390)
hgbot (developer)
2015-01-09 10:47

Repository: erp/devel/pi
Changeset: c055bf42b4fc6b5afb2aa441b632f62d1045eb30
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 09 10:46:48 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c055bf42b4fc6b5afb2aa441b632f62d1045eb30 [^]

fixed bug 28545: filters in HQL Query tables don't work in some cases

  Filters in HQL Query tables didn't work for columns having a different column
  name than its alias.

  This was caused because the reaplcement was not properly done because it didn't
  take into account the table alias.

  Table alias was added when fixing issue 0028432

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/HQLDataSourceService.java
---
(0073412)
AugustoMauch (manager)
2015-01-12 11:16

Code reviewed and verified in pi@5f64300e4811
(0073420)
hgbot (developer)
2015-01-12 13:03

Repository: erp/devel/pi
Changeset: bb8a5a244bfb4ef46e74413a58bd418df2c3562e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Jan 12 13:02:24 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bb8a5a244bfb4ef46e74413a58bd418df2c3562e [^]

related to bug 28545: added jUnit test case

---
M src-test/src/org/openbravo/test/AllWebserviceTests.java
A src-test/src/org/openbravo/test/datasource/HQLDataSourceTest.java
---
(0074130)
hudsonbot (developer)
2015-02-04 20:33

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f36c91d0ad63 [^]
Maturity status: Test
(0074135)
hudsonbot (developer)
2015-02-04 20:33

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f36c91d0ad63 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2015-01-08 17:12 umartirena New Issue
2015-01-08 17:12 umartirena Assigned To => AugustoMauch
2015-01-08 17:12 umartirena Modules => Core
2015-01-08 17:12 umartirena Triggers an Emergency Pack => No
2015-01-08 17:26 alostale Regression level => Packaging and release
2015-01-08 17:26 alostale Regression introduced in release => main
2015-01-08 17:26 alostale Severity critical => major
2015-01-09 09:51 alostale Relationship added caused by 0028432
2015-01-09 09:52 alostale Regression date => 2014-12-22
2015-01-09 09:52 alostale Regression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87dhttp://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87d [^]
2015-01-09 10:01 AugustoMauch Regression introduced by commit http://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87dhttp://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87d [^] => http://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87d [^]
2015-01-09 10:47 hgbot Checkin
2015-01-09 10:47 hgbot Note Added: 0073390
2015-01-09 10:47 hgbot Status new => resolved
2015-01-09 10:47 hgbot Resolution open => fixed
2015-01-09 10:47 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c055bf42b4fc6b5afb2aa441b632f62d1045eb30 [^]
2015-01-09 10:48 alostale Assigned To AugustoMauch => alostale
2015-01-09 10:48 alostale Review Assigned To => AugustoMauch
2015-01-12 11:16 AugustoMauch Note Added: 0073412
2015-01-12 11:16 AugustoMauch Status resolved => closed
2015-01-12 11:16 AugustoMauch Fixed in Version => 3.0PR15Q2
2015-01-12 13:03 hgbot Checkin
2015-01-12 13:03 hgbot Note Added: 0073420
2015-01-12 13:18 alostale Relationship added related to 0028565
2015-02-04 20:33 hudsonbot Checkin
2015-02-04 20:33 hudsonbot Note Added: 0074130
2015-02-04 20:33 hudsonbot Checkin
2015-02-04 20:33 hudsonbot Note Added: 0074135


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker