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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028545

Openbravo ERP

A. Platform

public

2015-01-08 17:12

2015-02-04 20:33

Reporter

umartirena

Assigned To

alostale

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR15Q2

Merge Request Status

Review Assigned To

AugustoMauch

OBNetwork customer

Web browser

Modules

Core

Support ticket

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

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.

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

caused by	defect	0028432	3.0PR15Q1	closed	AugustoMauch	can't filter product FK drop down in return windows P&E
related to	defect	0028565		closed	umartirena	not possible to filter by LineNo field in Match LC Cost