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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029241
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2015-03-11 11:222015-03-17 08:48
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version3.0PR15Q2
StatusclosedFix in branchFixed in SCM revisionf906f479f709
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029241: can't filter by Attribute Set Value in Return P&E windows

DescriptionIn Return from Customer P&E it is not possible to filter by Attribute Set Value.

When the Attribute Set Value filter drop down list is opened, no items are displayed and a NPE is logged in openbravo.log:
867f0e26 3132367 [http-8080-3] ERROR org.openbravo.service.datasource.DataSourceServlet -
java.lang.NullPointerException
    at org.openbravo.service.datasource.HQLDataSourceService.getData(HQLDataSourceService.java:185)
    at org.openbravo.service.datasource.ReadOnlyDataSourceService.fetchJSONObject(ReadOnlyDataSourceService.java:137)
    at org.openbravo.service.datasource.ReadOnlyDataSourceService.fetch(ReadOnlyDataSourceService.java:70)
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:261)
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:747)
Steps To Reproduce-Open Return from customer
-Create a header
-Open Pick/Edit lines
-Select a line and select for that line a Return reason
-Done
-Open Pick/Edit lines
-Open Attribute Set Value filter drop down
  -> ERROR:
     * no items are shown
     * error is logged in openbravo.log

Same is reproducible in Return to Vendor
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 0029224 closedAugustoMauch can't filter by Return Reason in Return P&E windows 
related to defect 00314543.0PR16Q2 closedcaristu Not possible to filter by Attribute Set Value in Return From Customer pick/edit lines 

-  Notes
(0075607)
AugustoMauch (manager)
2015-03-16 10:05
edited on: 2015-03-16 10:06

Fixes issue 29224: Filters work properly in Return from/to P&E window default tip
author Augusto Mauch <augusto.mauch@openbravo.com>
Wed Mar 11 11:07:30 2015 +0100 (4 days ago)
changeset 26182 f906f479f709
parent 26181 35265c987291
Fixes issue 29224: Filters work properly in Return from/to P&E window
URL: https://code.openbravo.com/erp/devel/pi/rev/f906f479f709 [^]

The problem was that in this changeset [1] the way the distinct queries (done to populate the fk filter dropdowns) was modified. The query is different, and the way to process its results too. The change done in the result processing caused this issue. The query done to populate the Attribute Set Value drop down is the following:

select distinct attributeSetValue,attributeSetValue.description FROM MaterialMgmtShipmentInOutLine as iol left join iol.attributeSetValue as attributeSetValue join iol.shipmentReceipt as io where io.businessPartner.id = 'A6750F0D15334FB890C254369AC750A8' and io.processed = true and io.documentStatus <> 'VO' and io.salesTransaction = true and (select iol.salesOrderLine.orderDiscount from MaterialMgmtShipmentInOutLine as e where e.id = iol) is null and iol.client.id in ('0', '23C59575B9CF467C9620760EB255B389') AND iol.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A') AND (io.movementDate >= (now() - 90) or (case when (select ('Y') from OrderLine as ol where ol.salesOrder.id = 'F0D6700E7BD6499FA76C6D94014714E8' and ol.goodsShipmentLine = iol) is null then false else true end) = true) ORDER BY attributeSetValue.description

And this is the result returned in the test I did:

1 42EA0E631BDD4ED69D8C30723A5E81C8 [identifier: L582, entity: AttributeSetInstance], L582
2 NULL, NULL

With the previous way of processing the results the second record was ignored, but with the new one a NPE was being thrown.

[1] https://code.openbravo.com/erp/devel/pi/rev/95dd177fbbc7f18d448b3e31cc12b67dbc0cb87d [^]

(0075674)
alostale (manager)
2015-03-17 08:48

code reviewed.

tested both in Return from Customer and Return to Vendor:
-Attribute Set Value can be filtered when there are lines with value in that field
-Attribute Set Value can be filtered when there are no lines with value in that field

- Issue History
Date Modified Username Field Change
2015-03-11 11:22 AugustoMauch New Issue
2015-03-11 11:22 AugustoMauch Assigned To => AugustoMauch
2015-03-11 11:22 AugustoMauch Modules => Core
2015-03-11 11:22 AugustoMauch Triggers an Emergency Pack => No
2015-03-11 11:23 AugustoMauch Relationship added related to 0029224
2015-03-11 11:24 AugustoMauch Issue Monitored: alostale
2015-03-11 11:26 AugustoMauch Relationship added caused by 0028432
2015-03-11 13:34 AugustoMauch Status new => acknowledged
2015-03-16 09:51 AugustoMauch Status acknowledged => scheduled
2015-03-16 09:51 AugustoMauch Review Assigned To => alostale
2015-03-16 10:05 AugustoMauch Note Added: 0075607
2015-03-16 10:05 AugustoMauch Status scheduled => resolved
2015-03-16 10:05 AugustoMauch Fixed in Version => 3.0PR15Q2
2015-03-16 10:05 AugustoMauch Fixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/f906f479f709 [^]
2015-03-16 10:05 AugustoMauch Resolution open => fixed
2015-03-16 10:06 AugustoMauch Note Edited: 0075607 View Revisions
2015-03-17 08:48 alostale Note Added: 0075674
2015-03-17 08:48 alostale Status resolved => closed
2015-12-21 11:23 alostale Relationship added related to 0031454


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker