Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018765Openbravo ERPA. Platformpublic2011-10-12 12:502011-11-12 15:48
Reporterrgoris 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP6Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018765: AND and OR logic does not work in column filter expressions
DescriptionQueries such as 0...100 and >200 are very useful and expected. In current version these do not work yet.
Steps To ReproduceTyping the above query in an amount column only takes the last bit (>200) and ignores the first bit.
Proposed Solutionimplement both AND and OR. It would be great if both lowercase and uppercase would do the same.
Additional Information
TagsOB3-Reviewed
Relationships
Attached Filespng Error.PNG (75,570) 2011-10-25 09:35
https://issues.openbravo.com/file_download.php?file_id=4661&type=bug
png

png and-does-not-work.png (114,037) 2011-11-09 10:18
https://issues.openbravo.com/file_download.php?file_id=4739&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-10-12 12:50rgorisNew Issue
2011-10-12 12:50rgorisAssigned To => mtaal
2011-10-12 12:50rgorisModules => Core
2011-10-12 12:50rgorisOBNetwork customer => No
2011-10-21 17:26azabaletaIssue Monitored: azabaleta
2011-10-23 12:49mtaalNote Added: 0042000
2011-10-24 18:54jmonIssue Monitored: jmon
2011-10-25 09:35rgorisNote Added: 0042081
2011-10-25 09:35rgorisFile Added: Error.PNG
2011-10-25 09:36rgorisStatusnew => scheduled
2011-10-25 09:36rgorisfix_in_branch => pi
2011-10-25 09:48rgorisNote Edited: 0042081bug_revision_view_page.php?bugnote_id=0042081#r2831
2011-10-25 09:50rgorisNote Edited: 0042081bug_revision_view_page.php?bugnote_id=0042081#r2832
2011-10-25 10:14mtaalNote Added: 0042083
2011-10-25 10:14mtaalTarget Version3.0MP5 => 3.0MP6
2011-10-25 10:14mtaalfix_in_branchpi =>
2011-10-28 20:42iciordiaTag Attached: OB3-Reviewed
2011-11-05 23:37hgbotCheckin
2011-11-05 23:37hgbotNote Added: 0042637
2011-11-05 23:37hgbotStatusscheduled => resolved
2011-11-05 23:37hgbotResolutionopen => fixed
2011-11-05 23:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/832f9c67f42b9439f71382819f1c1c2c3aa34122 [^]
2011-11-07 17:42rgorisNote Added: 0042663
2011-11-07 17:47rgorisStatusresolved => new
2011-11-07 17:47rgorisResolutionfixed => open
2011-11-08 03:54hgbotCheckin
2011-11-08 03:54hgbotNote Added: 0042668
2011-11-08 03:54hgbotStatusnew => resolved
2011-11-08 03:54hgbotResolutionopen => fixed
2011-11-08 03:54hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/832f9c67f42b9439f71382819f1c1c2c3aa34122 [^] => http://code.openbravo.com/erp/devel/pi/rev/a5cfc47000ab75aa870971d66bf6f7b22ef3523f [^]
2011-11-09 10:18rgorisFile Added: and-does-not-work.png
2011-11-09 10:18rgorisNote Added: 0042689
2011-11-09 10:18rgorisStatusresolved => new
2011-11-09 10:18rgorisResolutionfixed => open
2011-11-09 12:59rgorisStatusnew => scheduled
2011-11-09 12:59rgorisfix_in_branch => pi
2011-11-09 12:59rgorisStatusscheduled => resolved
2011-11-09 12:59rgorisResolutionopen => fixed
2011-11-09 12:59rgorisStatusresolved => closed
2011-11-12 15:48hudsonbotCheckin
2011-11-12 15:48hudsonbotNote Added: 0042776
2011-11-12 15:48hudsonbotCheckin
2011-11-12 15:48hudsonbotNote Added: 0042783

Notes
(0042000)
mtaal   
2011-10-23 12:49   
This bug only occurs in combination with the ... expression, so this expression works fine:
<3 or >5

Seems to be a bug or feature in Smartclient, I asked about it on the smartclient forum:
http://forums.smartclient.com/showthread.php?p=75008#post75008 [^]

gr. Martin
(0042081)
rgoris   
2011-10-25 09:35   
(edited on: 2011-10-25 09:50)
just tested and produces error for OR, see image.

This has to to with a bug in Smartclient for combining ranges and ORs. Fix is pending on their end so we keep this issue open till then.

http://forums.smartclient.com/showthread.php?t=19348 [^]
(0042083)
mtaal   
2011-10-25 10:14   
Move to mp6, will hopefully be solved when upgrading smartclient, if they see this as a bug.
(0042637)
hgbot   
2011-11-05 23:37   
Repository: erp/devel/pi
Changeset: 832f9c67f42b9439f71382819f1c1c2c3aa34122
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sat Nov 05 23:36:04 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/832f9c67f42b9439f71382819f1c1c2c3aa34122 [^]

Fixes issue 18841: Upgrade smartclient workaround issues
Fixes issue 18765: AND and OR logic does not work in column filter expressions

---
M modules/org.openbravo.userinterface.smartclient/web/org.openbravo.userinterface.smartclient/js/ob-smartclient.js
---
(0042663)
rgoris   
2011-11-07 17:42   
error seems to have gone but now the query (0...100 and >200) is ignored on ENTER
(0042668)
hgbot   
2011-11-08 03:54   
Repository: erp/devel/pi
Changeset: a5cfc47000ab75aa870971d66bf6f7b22ef3523f
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Nov 08 03:54:05 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a5cfc47000ab75aa870971d66bf6f7b22ef3523f [^]

Fixes issue 18765: AND and OR logic does not work in column filter expressions

---
M modules/org.openbravo.userinterface.smartclient/web/org.openbravo.userinterface.smartclient/js/ob-smartclient.js
---
(0042689)
rgoris   
2011-11-09 10:18   
error has gone, query is not ignored anymore...but now it just does not work, see attached image
(0042776)
hudsonbot   
2011-11-12 15:48   
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/9752fe729257 [^]

Maturity status: Test
(0042783)
hudsonbot   
2011-11-12 15:48   
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/9752fe729257 [^]

Maturity status: Test