Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0040742Openbravo ERPA. Platformpublic2019-04-30 17:262019-05-07 11:15
malsasua 
caristu 
normalmajoralways
closedfixed 
5
 
3.0PR19Q23.0PR19Q2 
alostale
Core
Production - Confirmed Stable
2017-11-28
3.0PR18Q1
https://code.openbravo.com/erp/devel/pi/rev/90ee5c965823996a7b4c0ae17d3a3ca71e3fc703 [^]
No
0040742: Records can not be exported to CSV
In grid view, if you filter by creation date, the export process to CSV is not working
. 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)
No tags attached.
blocks defect 0040735 closed caristu Records can not be exported to CSV 
Issue History
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