Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022641Openbravo ERP03. Procurement managementpublic2012-12-20 11:262013-01-28 16:49
Reportermirurita 
Assigned Tomtaal 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version3.0MP20 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022641: Matched Invoices window: "Invoice Line" and "Goods Receipt Line" filter not working properly
DescriptionWhen you type in "Invoice Line" and "Goods Receipt Line" grid filters it shows "No items to show" white box instead of the checkbox list to apply a multiple filter.

At this point, if you press enter or just move the focus the filter is applied correctly.

Looking at the log there are two different errors:

Invoice Line
-------------
a26005a4 3907153 [TP-Processor6] ERROR org.openbravo.service.json.DefaultJsonDataService - org.openbravo.model.common.invoice.Invoice cannot be cast to java.util.Date
java.lang.ClassCastException: org.openbravo.model.common.invoice.Invoice cannot be cast to java.util.Date
    at org.openbravo.base.structure.IdentifierProvider.getIdentifier(IdentifierProvider.java:134)
    at org.openbravo.base.structure.IdentifierProvider.getIdentifier(IdentifierProvider.java:77)


Goods Receipt Line
-------------------
a26005a4 3952500 [TP-Processor6] INFO org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: could not execute query
a26005a4 3952648 [TP-Processor6] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
  Position: 26036
a26005a4 3952648 [TP-Processor6] ERROR org.openbravo.service.json.DefaultJsonDataService - could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
Steps To Reproduce1) Go to Matched Invoices window
2) Try to filter by Invoice Line or Goods Receipt Line columns
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0022849 new AugustoMauch Filtering on identifier columns with multiple values is not precise enough 
Attached Filespng grid_filter.png (95,995) 2012-12-20 11:26
https://issues.openbravo.com/file_download.php?file_id=5853&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-12-20 11:26miruritaNew Issue
2012-12-20 11:26miruritaAssigned To => dmiguelez
2012-12-20 11:26miruritaFile Added: grid_filter.png
2012-12-20 11:26miruritaModules => Core
2012-12-20 11:26miruritaOBNetwork customer => No
2012-12-20 11:26miruritaTriggers an Emergency Pack => No
2012-12-20 12:15dmiguelezAssigned Todmiguelez => dbaz
2012-12-20 12:16dmiguelezAssigned Todbaz => marvintm
2012-12-20 17:35dbazAssigned Tomarvintm => mtaal
2013-01-21 09:13mtaalReview Assigned To => AugustoMauch
2013-01-21 09:16hgbotCheckin
2013-01-21 09:16hgbotNote Added: 0055646
2013-01-21 09:16hgbotStatusnew => resolved
2013-01-21 09:16hgbotResolutionopen => fixed
2013-01-21 09:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ff4be9f0d015ed02c2c5ab79a22a29a6d0cc2eff [^]
2013-01-21 09:18mtaalRelationship addedrelated to 0022849
2013-01-22 15:33hudsonbotCheckin
2013-01-22 15:33hudsonbotNote Added: 0055729
2013-01-28 16:49AugustoMauchNote Added: 0055918
2013-01-28 16:49AugustoMauchStatusresolved => closed
2013-01-28 16:49AugustoMauchFixed in Version => 3.0MP20

Notes
(0055646)
hgbot   
2013-01-21 09:16   
Repository: erp/devel/pi
Changeset: ff4be9f0d015ed02c2c5ab79a22a29a6d0cc2eff
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon Jan 21 09:12:43 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ff4be9f0d015ed02c2c5ab79a22a29a6d0cc2eff [^]

Fixes issue 22641: Matched Invoices window: "Invoice Line" and "Goods Receipt Line" filter not working properly

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
M src/org/openbravo/base/structure/IdentifierProvider.java
---
(0055729)
hudsonbot   
2013-01-22 15: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/449aae8be624 [^]

Maturity status: Test
(0055918)
AugustoMauch   
2013-01-28 16:49   
Code reviewed and verified in pi@e035b2855377