Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0013917Openbravo ERPZ. Otherspublic2010-07-07 18:542012-05-09 17:03
shuehner 
gorkaion 
normalminorhave not tried
closedunable to reproduce 
5
2.50 
 
User Interface Selector
No
0013917: HQL error shown when using multiple identifier fields
When having multiple identifer fields defined for a table then in at least one specific usecase an hql error is shown. See screenshot for error details and steps down below.

Note using latest version of all modules from hg:
- json: 9622a61b5490
- datasource: 542e2bac53ba
- selector: a04c7f1f7b73
Mark name+description of m_product as identifier columns
define a new selector based on m_product with two selector field name & description
do not mark any of those two as 'search in suggestion box'
Modify the column product of the lines tab of the physical inventory window to use the newly defined selector
recompile+redeploy+restart tomcat
go to the physical inventroy tab and create a new line
enter 't - 1' (without the ') in the suggestion box and accept the suggest paint - 1.5 kg tin...' entry
open the selector overlay and use the 'x' for the name column to clear the filter
click cancel in the selector
now mark all text in the selector textfield and type 'paint'
-> see hql error like in attached screenshot
No tags attached.
related to defect 00128292.50 closed mtaal Check/improve the querying in case of types with multiple identifier columns 
related to feature request 0012808 new Triage Platform Base Check if popup contains filter which is typed in selector field 
png 13917.png (12,107) 2010-07-07 18:57
https://issues.openbravo.com/file_download.php?file_id=2753&type=bug
png
Issue History
2010-07-07 18:54shuehnerNew Issue
2010-07-07 18:54shuehnerAssigned To => mtaal
2010-07-07 18:57shuehnerFile Added: 13917.png
2010-07-07 18:58shuehnerRelationship addedrelated to 0012829
2010-07-07 18:58shuehnerRelationship addedrelated to 0012808
2010-12-06 07:48alostaleStatusnew => scheduled
2011-03-01 08:49mtaalAssigned Tomtaal => gorkaion
2012-05-09 17:03miruritaNote Added: 0048515
2012-05-09 17:03miruritaStatusscheduled => closed
2012-05-09 17:03miruritaResolutionopen => unable to reproduce

Notes
(0048515)
mirurita   
2012-05-09 17:03   
I'm not able to reproduce this issue.
Following described steps to reproduce the application is not showing any error.