Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0013997 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | have not tried | 2010-07-19 14:02 | 2010-12-09 16:03 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 23d46a3be745 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | User Interface Selector | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0013997: When using a default exrpession for a numeric field then on searching in the suggestion box a hql error is shown | |||||||
| Description | Defining 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  org.test2-0.0.1.obx [^] (4,672 bytes) 2010-07-19 14:02 org.test-0.0.0.obx [^] (2,480 bytes) 2010-07-19 14:02 13997.png [^] (13,550 bytes) 2010-07-19 14:03
org.test2-0.0.2.obx [^] (5,269 bytes) 2010-07-19 19:37 org.test-0.0.1.obx [^] (2,578 bytes) 2010-07-19 19:37 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0029384) shuehner (administrator) 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 (administrator) 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 (developer) 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 (developer) 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 (administrator) 2010-07-21 14:01 |
Reviewed+Tested on latest module version on pi_pgsql. Both testcases now work fine. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-07-19 14:02 | shuehner | New Issue | |
| 2010-07-19 14:02 | shuehner | Assigned To | => iperdomo |
| 2010-07-19 14:02 | shuehner | File Added: org.test2-0.0.1.obx | |
| 2010-07-19 14:02 | shuehner | File Added: org.test-0.0.0.obx | |
| 2010-07-19 14:03 | shuehner | File Added: 13997.png | |
| 2010-07-19 14:06 | iperdomo | Status | new => acknowledged |
| 2010-07-19 14:20 | shuehner | Note Added: 0029384 | |
| 2010-07-19 19:37 | shuehner | File Added: org.test2-0.0.2.obx | |
| 2010-07-19 19:37 | shuehner | File Added: org.test-0.0.1.obx | |
| 2010-07-19 19:39 | shuehner | Note Added: 0029391 | |
| 2010-07-20 10:31 | iperdomo | Relationship added | blocks 0013458 |
| 2010-07-20 10:31 | iperdomo | Status | acknowledged => scheduled |
| 2010-07-20 10:31 | iperdomo | fix_in_branch | => pi |
| 2010-07-20 10:55 | rafaroda | Issue Monitored: rafaroda | |
| 2010-07-20 16:53 | hgbot | Checkin | |
| 2010-07-20 16:53 | hgbot | Note Added: 0029411 | |
| 2010-07-20 16:53 | hgbot | Status | scheduled => resolved |
| 2010-07-20 16:53 | hgbot | Resolution | open => fixed |
| 2010-07-20 16:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/dbe5eed0e0e770bc8fe27c8411f76d3c93078ad0 [^] |
| 2010-07-20 16:55 | hgbot | Checkin | |
| 2010-07-20 16:55 | hgbot | Note Added: 0029412 | |
| 2010-07-20 16:55 | hgbot | Fixed in SCM revision | http://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:01 | shuehner | Note Added: 0029440 | |
| 2010-07-21 14:01 | shuehner | Status | resolved => closed |
| 2010-12-09 16:03 | anonymous | sf_bug_id | 0 => 3133320 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |