Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012829Openbravo ERPZ. Otherspublic2010-03-26 23:382010-12-09 16:00
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target Version2.50Fixed in Version 
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
Summary0012829: Check/improve the querying in case of types with multiple identifier columns
DescriptionCurrently when a type has multiple identifier fields then the selector will search the identifier fields individually and not concatenated. This can result in unexpected search behavior for the user:

This is summarized with the following statement:
"Also startswith won't concatenate the identifier columns in the database at the moment" -> does it mean that if an identifier is 'FN100 - Euro' and I type 'FN100 - E' it will return no values?
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0013917 closed gorkaion HQL error shown when using multiple identifier fields 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-26 23:38mtaalNew Issue
2010-03-26 23:38mtaalAssigned To => mtaal
2010-03-26 23:38mtaalOBNetwork customer => No
2010-03-31 11:53hgbotCheckin
2010-03-31 11:53hgbotNote Added: 0025830
2010-03-31 11:53hgbotStatusnew => resolved
2010-03-31 11:53hgbotResolutionopen => fixed
2010-03-31 11:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.service.json/rev/ce058489055a62b35686c172130eb009e34ff3eb [^]
2010-07-07 18:58shuehnerRelationship addedrelated to 0013917
2010-07-07 18:59shuehnerNote Added: 0029142
2010-07-07 18:59shuehnerStatusresolved => closed
2010-12-09 16:00anonymoussf_bug_id0 => 3133091

Notes
(0025830)
hgbot   
2010-03-31 11:53   
Repository: erp/mods/org.openbravo.service.json
Changeset: ce058489055a62b35686c172130eb009e34ff3eb
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Mar 31 12:02:53 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.service.json/rev/ce058489055a62b35686c172130eb009e34ff3eb [^]

Fixes issue 12829: Check/improve the querying in case of types with multiple identifier columns

---
M src/org/openbravo/service/json/DataEntityQueryService.java
M src/org/openbravo/service/json/QueryBuilder.java
---
(0029142)
shuehner   
2010-07-07 18:59   
Tested using multi-part identifier now working fine. However issue 13917 was found during testing which my be related.