Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013997
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajorhave not tried2010-07-19 14:022010-12-09 16:03
ReportershuehnerView Statuspublic 
Assigned Toiperdomo 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision23d46a3be745
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesUser Interface Selector
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013997: 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.
TagsNo tags attached.
Attached Files? file icon org.test2-0.0.1.obx [^] (4,672 bytes) 2010-07-19 14:02
? file icon org.test-0.0.0.obx [^] (2,480 bytes) 2010-07-19 14:02
png file icon 13997.png [^] (13,550 bytes) 2010-07-19 14:03


? file icon org.test2-0.0.2.obx [^] (5,269 bytes) 2010-07-19 19:37
? file icon org.test-0.0.1.obx [^] (2,578 bytes) 2010-07-19 19:37

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks feature request 0013458 closediperdomo It should be possible to assignes default values for fields on selectors 

-  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.

- 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 OBNetwork customer => No
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker