Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013997Openbravo ERPZ. Otherspublic2010-07-19 14:022010-12-09 16:03
Reportershuehner 
Assigned Toiperdomo 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesUser Interface Selector
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013997: When using a default exrpession for a numeric field then on searching in the suggestion box a hql error is shown
DescriptionDefining a selector based on m_product, with a numeric selector field and using this new selector in a window (i.e. physical inventory::lines) leads to an hql error shown when typing in the suggestion box.

See attached two modules for exact selector definition.

the test2 module contains the new selector definition
the text module is a template which modifies the product field in the lines tab of the Physical Inventory window.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0013458 closed iperdomo It should be possible to assignes default values for fields on selectors 
Attached Files? org.test2-0.0.1.obx (4,672) 2010-07-19 14:02
https://issues.openbravo.com/file_download.php?file_id=2780&type=bug
? org.test-0.0.0.obx (2,480) 2010-07-19 14:02
https://issues.openbravo.com/file_download.php?file_id=2781&type=bug
png 13997.png (13,550) 2010-07-19 14:03
https://issues.openbravo.com/file_download.php?file_id=2782&type=bug
png

? org.test2-0.0.2.obx (5,269) 2010-07-19 19:37
https://issues.openbravo.com/file_download.php?file_id=2783&type=bug
? org.test-0.0.1.obx (2,578) 2010-07-19 19:37
https://issues.openbravo.com/file_download.php?file_id=2784&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-07-19 14:02shuehnerNew Issue
2010-07-19 14:02shuehnerAssigned To => iperdomo
2010-07-19 14:02shuehnerFile Added: org.test2-0.0.1.obx
2010-07-19 14:02shuehnerFile Added: org.test-0.0.0.obx
2010-07-19 14:03shuehnerFile Added: 13997.png
2010-07-19 14:06iperdomoStatusnew => acknowledged
2010-07-19 14:20shuehnerNote Added: 0029384
2010-07-19 19:37shuehnerFile Added: org.test2-0.0.2.obx
2010-07-19 19:37shuehnerFile Added: org.test-0.0.1.obx
2010-07-19 19:39shuehnerNote Added: 0029391
2010-07-20 10:31iperdomoRelationship addedblocks 0013458
2010-07-20 10:31iperdomoStatusacknowledged => scheduled
2010-07-20 10:31iperdomofix_in_branch => pi
2010-07-20 10:55rafarodaIssue Monitored: rafaroda
2010-07-20 16:53hgbotCheckin
2010-07-20 16:53hgbotNote Added: 0029411
2010-07-20 16:53hgbotStatusscheduled => resolved
2010-07-20 16:53hgbotResolutionopen => fixed
2010-07-20 16:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/dbe5eed0e0e770bc8fe27c8411f76d3c93078ad0 [^]
2010-07-20 16:55hgbotCheckin
2010-07-20 16:55hgbotNote Added: 0029412
2010-07-20 16:55hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/dbe5eed0e0e770bc8fe27c8411f76d3c93078ad0 [^] => http://code.openbravo.com/erp/mods/org.openbravo.service.datasource/rev/23d46a3be7459943317d1fe65129462aaea7a4fd [^]
2010-07-21 14:01shuehnerNote Added: 0029440
2010-07-21 14:01shuehnerStatusresolved => closed
2010-12-09 16:03anonymoussf_bug_id0 => 3133320

Notes
(0029384)
shuehner   
2010-07-19 14:20   
Note problem is not restricted to numeric fields. Removing the default expression from the numeric field and adding 'test' as default expression on the name field leads to essentially the same error (dangling and in front of hql-part for default expression)
(0029391)
shuehner   
2010-07-19 19:39   
Added second set of the same moduleSs:
changes compared to first set of of moduleS:
- removed default filter from numeric field
- added new selector based on businesspartner (used in c_order table (Purchase Order,Sales Order). This one uses default filter expression shown in the Selector documentation page. When opening page (i.e. Purchase Order) a similar hql error is shown (dangling AND without any expressions next to it).
(0029411)
hgbot   
2010-07-20 16:53   
Repository: erp/mods/org.openbravo.userinterface.selector
Changeset: dbe5eed0e0e770bc8fe27c8411f76d3c93078ad0
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Tue Jul 20 16:53:11 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/dbe5eed0e0e770bc8fe27c8411f76d3c93078ad0 [^]

Fixes Issue 13997: Added extra check for empty results

---
M src/org/openbravo/userinterface/selector/SelectorDataSourceFilter.java
---
(0029412)
hgbot   
2010-07-20 16:55   
Repository: erp/mods/org.openbravo.service.datasource
Changeset: 23d46a3be7459943317d1fe65129462aaea7a4fd
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Tue Jul 20 16:55:16 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.service.datasource/rev/23d46a3be7459943317d1fe65129462aaea7a4fd [^]

Fixes issue 13997: Added extra check for empty/null where clause

---
M src/org/openbravo/service/datasource/DefaultDataSourceService.java
---
(0029440)
shuehner   
2010-07-21 14:01   
Reviewed+Tested on latest module version on pi_pgsql. Both testcases now work fine.