Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0028545 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2015-01-08 17:12 | 2015-02-04 20:33 | |||
| Reporter | umartirena | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0PR15Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | c055bf42b4fc | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | AugustoMauch | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | Packaging and release | |||||||
| Regression date | 2014-12-22 | |||||||
| Regression introduced in release | main | |||||||
| Regression introduced by commit | http://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87d [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0028545: Some filters in Grids built on HQL Based Table they don't work any more | |||||||
| Description | Some 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 Reproduce | In 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
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 (administrator) 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 |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |