Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040917Openbravo ERPA. Platformpublic2019-05-07 13:462019-05-24 10:37
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q1.2Fixed in Version3.0PR19Q1.2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040917: Use as filter option is not working properly with date columns
DescriptionUse as filter option is not working properly with date columns
Steps To Reproduce1) Go to the [Process Monitor] window
2) Select any record
3) Move the cursor to the "Start Time" column, right click and select "Set As Filter" option
4) Note that the text in the filter field is correctly updated but the result of the filtering is not correct
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0040802 closed caristu Use as filter option is not working properly with date columns 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-05-20 13:04caristuTypedefect => backport
2019-05-20 13:04caristuTarget Version => 3.0PR19Q1.2
2019-05-20 18:13hgbotCheckin
2019-05-20 18:13hgbotNote Added: 0111936
2019-05-20 18:13hgbotStatusscheduled => resolved
2019-05-20 18:13hgbotResolutionopen => fixed
2019-05-20 18:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q1.2/rev/747a7b4ed0107fa816de9687a2921140b6c24616 [^]
2019-05-20 18:13caristuReview Assigned To => alostale
2019-05-24 10:37alostaleNote Added: 0112116
2019-05-24 10:37alostaleStatusresolved => closed
2019-05-24 10:37alostaleFixed in Version => 3.0PR19Q1.2

Notes
(0111936)
hgbot   
2019-05-20 18:13   
Repository: erp/backports/3.0PR19Q1.2
Changeset: 747a7b4ed0107fa816de9687a2921140b6c24616
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon May 20 16:11:56 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q1.2/rev/747a7b4ed0107fa816de9687a2921140b6c24616 [^]

fixes bug 40917: "Use as filter" is not working properly with DateTime columns

  After this changeset[1] it was fixed the ability to filter properly by a range of DateTime values. However, this change broke the correct filtering by a single DateTime value in this type of columns.

  But when filtering a DateTime column with a single DateTime value (when not filtering by a range of dates), in general, the idea is to use the plain date value and build the criteria properly in the backend(See[2]).

  Therefore now we are adapting the way that the criteria is build using the "Use as Filter" menu option to generate the criteria in the same way as when the filter is entered manually in a DateTime column. And this is done by building the criteria to filter the DateTime column using a plain date.


[1] https://code.openbravo.com/erp/devel/pi/rev/90ee5c965823996a7b4c0ae17d3a3ca71e3fc703 [^]
[2] https://issues.openbravo.com/view.php?id=23203 [^]

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
---
(0112116)
alostale   
2019-05-24 10:37   
reviewed + tested