Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027679Openbravo ERPA. Platformpublic2014-09-25 10:352014-09-26 19:08
Reporteralostale 
Assigned Toshankarb 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2014-02-26
Regression introduced in release3.0PR14Q2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/20eb3426d990 [^]
Triggers an Emergency PackNo
Summary0027679: can't use FK drop down if grid is already filtered by a relative date
DescriptionFilter drop down for FK columns doesn't show any value when the grid is already filtered by a relative date.

This is the backend error:
7bb7455f 856619 [http-8080-3] ERROR org.openbravo.service.json.DefaultJsonDataService - Invalid filter value {"_constructor":"RelativeDate","value":"$today","rangePosition":"end"}.
org.openbravo.base.exception.OBException: Invalid filter value {"_constructor":"RelativeDate","value":"$today","rangePosition":"end"}.

The problem is in the request that is sent in this case, the criteria uses the RelativeDate which is not implemented in Backed.

Previous to 3.0PR14Q2 the criteria parameter converted relative date into absolute date, so it looked like:
criteria:{"fieldName":"orderDate","operator":"lessOrEqual","value":"2014-09-25T21:59:59","_constructor":"AdvancedCriteria"}
Steps To Reproduce-Open Sales Order window
-Filter Order Date field selecting To Today in the filter popup
-Try to open Business Partner drop down list to filter by this field -> No items to show is displayed

Proposed SolutionChange client to work as it did previous to Q2 converting relative into absolute dates
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0025574 closed dbaz Upgrade SmartClient 10.0d 
causes defect 0029010 closed AugustoMauch the grid is filtering by relative date not the absolute 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-09-25 10:35alostaleNew Issue
2014-09-25 10:35alostaleAssigned To => AugustoMauch
2014-09-25 10:35alostaleModules => Core
2014-09-25 10:35alostaleRegression level => Production - Confirmed Stable
2014-09-25 10:35alostaleTriggers an Emergency Pack => No
2014-09-25 10:37alostaleRegression introduced in release => 3.0PR14Q2
2014-09-25 10:47alostaleAssigned ToAugustoMauch => shankarb
2014-09-25 13:35shankarbRegression date => 2014-02-26
2014-09-25 13:35shankarbRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/20eb3426d990 [^]
2014-09-25 13:38shankarbReview Assigned To => alostale
2014-09-25 13:38shankarbIssue Monitored: alostale
2014-09-26 07:39hgbotCheckin
2014-09-26 07:39hgbotNote Added: 0070418
2014-09-26 07:39hgbotStatusnew => resolved
2014-09-26 07:39hgbotResolutionopen => fixed
2014-09-26 07:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/653cc69090124def179091b96d9d2d820cc47d2b [^]
2014-09-26 09:05alostaleStatusresolved => new
2014-09-26 09:05alostaleResolutionfixed => open
2014-09-26 09:05alostaleRelationship addedcaused by 0025574
2014-09-26 09:05alostaleStatusnew => scheduled
2014-09-26 09:05alostalefix_in_branch => pi
2014-09-26 09:06alostaleStatusscheduled => resolved
2014-09-26 09:06alostaleResolutionopen => fixed
2014-09-26 09:49alostaleNote Added: 0070429
2014-09-26 09:49alostaleStatusresolved => closed
2014-09-26 09:49alostaleFixed in Version => 3.0PR14Q4
2014-09-26 19:08hudsonbotCheckin
2014-09-26 19:08hudsonbotNote Added: 0070454
2015-02-25 08:38alostaleRelationship addedcauses 0029010

Notes
(0070418)
hgbot   
2014-09-26 07:39   
Repository: erp/devel/pi
Changeset: 653cc69090124def179091b96d9d2d820cc47d2b
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu Sep 25 17:06:26 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/653cc69090124def179091b96d9d2d820cc47d2b [^]

Fixes Issue 27679: can't use FK drop down if grid is already filtered by a relative date

Convert relative dates in criteria to absolute dates.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
---
(0070429)
alostale   
2014-09-26 09:49   
code reviewed

tested:
- following issue's steps to reproduce
- saving a view with this filter work fine
(0070454)
hudsonbot   
2014-09-26 19:08   
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/37b816a315f2 [^]
Maturity status: Test