Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040743Openbravo ERPA. Platformpublic2019-04-30 17:262019-05-21 15:16
Reportermalsasua 
Assigned Tocaristu 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q1.1Fixed in Version3.0PR19Q1.1 
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
Summary0040743: 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.0PR19Q1.1
2019-05-02 17:18caristuTarget Version3.0PR19Q1.1 => 3.0PR19Q1.2
2019-05-06 09:51hgbotCheckin
2019-05-06 09:51hgbotNote Added: 0111489
2019-05-06 09:51hgbotStatusscheduled => resolved
2019-05-06 09:51hgbotResolutionopen => fixed
2019-05-06 09:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3d7237675ba21defe75727ff05f83b132cee64ad [^]
2019-05-06 09:52caristuStatusresolved => new
2019-05-06 09:52caristuResolutionfixed => open
2019-05-06 11:51hgbotCheckin
2019-05-06 11:51hgbotNote Added: 0111495
2019-05-06 11:51hgbotStatusnew => resolved
2019-05-06 11:51hgbotResolutionopen => fixed
2019-05-06 11:51hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/3d7237675ba21defe75727ff05f83b132cee64ad [^] => http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/2a604c499abc2389e5ddce95333f8211be581a6e [^]
2019-05-06 11:52caristuReview Assigned To => alostale
2019-05-06 11:52caristuNote Deleted: 0111489
2019-05-06 11:52caristuTarget Version3.0PR19Q1.2 => 3.0PR19Q1.1
2019-05-07 11:15alostaleNote Added: 0111529
2019-05-07 11:15alostaleStatusresolved => closed
2019-05-07 11:15alostaleFixed in Version => 3.0PR19Q1.1
2019-05-21 15:16hudsonbotCheckin
2019-05-21 15:16hudsonbotNote Added: 0112008

Notes
(0111495)
hgbot   
2019-05-06 11:51   
Repository: erp/backports/3.0PR19Q1.1
Changeset: 2a604c499abc2389e5ddce95333f8211be581a6e
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon May 06 11:49:42 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/2a604c499abc2389e5ddce95333f8211be581a6e [^]

fixes issue 40743: 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.

[1] https://code.openbravo.com/erp/devel/pi/rev/90ee5c965823996a7b4c0ae17d3a3ca71e3fc703 [^]

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-grid.js
---
(0111529)
alostale   
2019-05-07 11:15   
reviewed + tested
(0112008)
hudsonbot   
2019-05-21 15:16   
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/9b8f37d9d85e [^]
Maturity status: Test