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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0022641
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2012-12-20 11:262013-01-28 16:49
ReportermiruritaView Statuspublic 
Assigned Tomtaal 
PriorityhighResolutionfixedFixed in Version3.0MP20
StatusclosedFix in branchFixed in SCM revisionff4be9f0d015
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022641: 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
TagsNo tags attached.
Attached Filespng file icon grid_filter.png [^] (95,995 bytes) 2012-12-20 11:26

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0022849 newAugustoMauch Filtering on identifier columns with multiple values is not precise enough 

-  Notes
(0055646)
hgbot (developer)
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 (developer)
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 (administrator)
2013-01-28 16:49

 Code reviewed and verified in pi@e035b2855377

- Issue History
Date Modified Username Field Change
2012-12-20 11:26 mirurita New Issue
2012-12-20 11:26 mirurita Assigned To => dmiguelez
2012-12-20 11:26 mirurita File Added: grid_filter.png
2012-12-20 11:26 mirurita Modules => Core
2012-12-20 11:26 mirurita Triggers an Emergency Pack => No
2012-12-20 12:15 dmiguelez Assigned To dmiguelez => dbaz
2012-12-20 12:16 dmiguelez Assigned To dbaz => marvintm
2012-12-20 17:35 dbaz Assigned To marvintm => mtaal
2013-01-21 09:13 mtaal Review Assigned To => AugustoMauch
2013-01-21 09:16 hgbot Checkin
2013-01-21 09:16 hgbot Note Added: 0055646
2013-01-21 09:16 hgbot Status new => resolved
2013-01-21 09:16 hgbot Resolution open => fixed
2013-01-21 09:16 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ff4be9f0d015ed02c2c5ab79a22a29a6d0cc2eff [^]
2013-01-21 09:18 mtaal Relationship added related to 0022849
2013-01-22 15:33 hudsonbot Checkin
2013-01-22 15:33 hudsonbot Note Added: 0055729
2013-01-28 16:49 AugustoMauch Note Added: 0055918
2013-01-28 16:49 AugustoMauch Status resolved => closed
2013-01-28 16:49 AugustoMauch Fixed in Version => 3.0MP20

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker