Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040742Openbravo ERPA. Platformpublic2019-04-30 17:262019-05-07 11:15
Reportermalsasua 
Assigned Tocaristu 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q2Fixed in Version3.0PR19Q2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerNo
Web browser
ModulesCore
Support ticket9680
Regression levelProduction - Confirmed Stable
Regression date2017-11-28
Regression introduced in release3.0PR18Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/90ee5c965823996a7b4c0ae17d3a3ca71e3fc703 [^]
Triggers an Emergency PackNo
Summary0040742: Records can not be exported to CSV
DescriptionIn grid view, if you filter by creation date, the export process to CSV is not working
Steps To Reproduce. go to Business Partner window
. in grid view, add column "Creation Date"
. filter by Creation Date (see screenshot attached)
. click in Export to Spreadsheet button
CSV file is downloaded but it is empty (see file attached)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0040735 closed caristu Records can not be exported to CSV 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-05-02 11:29caristuTypedefect => backport
2019-05-02 11:29caristuTarget Version => 3.0PR19Q2
2019-05-06 10:10hgbotCheckin
2019-05-06 10:10hgbotNote Added: 0111491
2019-05-06 10:10hgbotStatusscheduled => resolved
2019-05-06 10:10hgbotResolutionopen => fixed
2019-05-06 10:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q2/rev/d8689f27a689fb1fed512dd020a6317f9de06341 [^]
2019-05-06 11:53caristuReview Assigned To => alostale
2019-05-07 11:15alostaleNote Added: 0111531
2019-05-07 11:15alostaleStatusresolved => closed
2019-05-07 11:15alostaleFixed in Version => 3.0PR19Q2

Notes
(0111491)
hgbot   
2019-05-06 10:10   
Repository: erp/backports/3.0PR19Q2
Changeset: d8689f27a689fb1fed512dd020a6317f9de06341
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon May 06 10:09:03 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q2/rev/d8689f27a689fb1fed512dd020a6317f9de06341 [^]

fixes issue 40742: wrong export to CSV having the grid filtered by a date time

After the following changeset[1], exporting the grid to CSV was not working properly having the grid filtered by a date time column. Although the fix is correct, it caused the criteria sent to the datasource in this type of requests to stop being handled properly.

To avoid this problem, when exporting to CSV a grid filtered by a date time column we send in the criteria the plain date (in the same way as it is being done for the standard grid DS requests) and the datasource will take care of building the date filter properly through the AdvancedQueryBuilder.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-grid.js
---
(0111531)
alostale   
2019-05-07 11:15   
reviewed + tested