Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018767Openbravo ERPA. Platformpublic2011-10-13 09:142011-10-25 10:42
Reporterrgoris 
Assigned Tomtaal 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018767: More filter expressions that do not work
Description!^ (does not start with) e.g. !^H ->does not work
!@ (does not end with) e.g. !@H ->does not work
! (not equal), e.g. !100 ->works well but after hitting ENTER the filter itself disappears. This problem only occurs in numerical columns.
# (is Null) , see images for example where it does not work well

Also, there is another issue that the counter sometimes disappears after having applied a filter. This is when you type an expression in a "string-column" and hit enter. See image.
Steps To ReproduceTry the above in sales invoice grid on live builds
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng null-0.png (66,527) 2011-10-13 09:23
https://issues.openbravo.com/file_download.php?file_id=4636&type=bug
png

png null-1.png (40,828) 2011-10-13 09:23
https://issues.openbravo.com/file_download.php?file_id=4637&type=bug
png

png counter-gone.PNG (40,881) 2011-10-13 09:26
https://issues.openbravo.com/file_download.php?file_id=4638&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-10-13 09:14rgorisNew Issue
2011-10-13 09:14rgorisAssigned To => mtaal
2011-10-13 09:14rgorisModules => Core
2011-10-13 09:15rgorisStatusnew => scheduled
2011-10-13 09:15rgorisNote Added: 0041782
2011-10-13 09:15rgorisfix_in_branch => pi
2011-10-13 09:22rgorisfix_in_branchpi =>
2011-10-13 09:22rgorisDescription Updatedbug_revision_view_page.php?rev_id=2810#r2810
2011-10-13 09:23rgorisFile Added: null-0.png
2011-10-13 09:23rgorisFile Added: null-1.png
2011-10-13 09:25rgorisDescription Updatedbug_revision_view_page.php?rev_id=2811#r2811
2011-10-13 09:26rgorisFile Added: counter-gone.PNG
2011-10-13 09:29rgorisTarget Version3.0MP5 => 3.0MP4
2011-10-13 09:46hgbotCheckin
2011-10-13 09:46hgbotNote Added: 0041783
2011-10-13 11:04rgorisNote Added: 0041786
2011-10-14 12:06marvintmNote Added: 0041835
2011-10-14 12:11mtaalNote Added: 0041836
2011-10-18 17:24hgbotCheckin
2011-10-18 17:24hgbotNote Added: 0041883
2011-10-18 17:26hudsonbotCheckin
2011-10-18 17:26hudsonbotNote Added: 0041886
2011-10-21 18:09hgbotCheckin
2011-10-21 18:09hgbotNote Added: 0041984
2011-10-23 13:42hudsonbotCheckin
2011-10-23 13:42hudsonbotNote Added: 0042040
2011-10-25 10:42rgorisStatusscheduled => resolved
2011-10-25 10:42rgorisFixed in SCM revision => pi
2011-10-25 10:42rgorisResolutionopen => fixed
2011-10-25 10:42rgorisStatusresolved => closed

Notes
(0041782)
rgoris   
2011-10-13 09:15   
Doing this also for MP4 is impossible, I assume?
(0041783)
hgbot   
2011-10-13 09:46   
Repository: erp/devel/pi
Changeset: c539e5866861b2274e271fef048187a5126fb574
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Oct 13 09:45:36 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c539e5866861b2274e271fef048187a5126fb574 [^]

Related to issue 18767: More filter expressions that do not work
Fix # and disappearing of count in grid

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0041786)
rgoris   
2011-10-13 11:04   
It seems to be a Firefox issue. All (except for #) work well in Chrome, but not in Firefox.
(0041835)
marvintm   
2011-10-14 12:06   
Tested that in Firefox and Chrome the issue related to the count disappearing can no longer be reproduced
(0041836)
mtaal   
2011-10-14 12:11   
Issue with SC for not equal filtering:
http://forums.smartclient.com/showthread.php?p=74633#post74633 [^]
(0041883)
hgbot   
2011-10-18 17:24   
Repository: erp/devel/pi
Changeset: d70a5e662ec831ac4c6f8db12cd10a11dbc6c88d
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Oct 13 09:45:36 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d70a5e662ec831ac4c6f8db12cd10a11dbc6c88d [^]

Related to issue 18767: More filter expressions that do not work
Fix # and disappearing of count in grid

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0041886)
hudsonbot   
2011-10-18 17:26   
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/3a0e09f510aa [^]

Maturity status: Test
(0041984)
hgbot   
2011-10-21 18:09   
Repository: erp/devel/pi
Changeset: 92424856a8ad6c51c76bd1f38a72c9250cf90a2e
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Fri Oct 21 18:09:14 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/92424856a8ad6c51c76bd1f38a72c9250cf90a2e [^]

Related to issue 18767: More filter expressions that do not work
Let startswith and endswith work correctly

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0042040)
hudsonbot   
2011-10-23 13:42   
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/35bf0a7aa166 [^]

Maturity status: Test