Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajorhave not tried2022-07-18 11:142023-01-31 08:29
ReporterjarmendarizView Statuspublic 
Assigned Togonzalo_fernandez 
PrioritynormalResolutionfixedFixed in VersionPR23Q2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0049826: Foreign key selector within Custom HQL selector grid does not show proper values

DescriptionIn a Selector Reference we can define a field that refers to a foreign reference to another table. In that case, in the grid view we see a dropdown selector for that field that shows all available values with the current filter.

In case this selector uses an custom HQL query, that foreign key selector does not group its values by the foreign key and shows a list of checkboxes with no label. [^]
Steps To Reproduce- Log in as System administrator
- Go to Reference Window
- Select 'On hand warehouse'
- On Tab 'Defined Selector', double click the associated entry
- Modify the HQL query to add a location address field and save:

select as id, as name, w.locationAddress as location
from Warehouse w
where @additional_filters@

- In subtab 'Defined Selector Field' create a new entry with the following info:
  - Name: location
  - Display column alias: location
  - Reference: C_Location
  - Show in grid: Yes
  - Clause left part: w.locationAddress

Logout then login and switch to 'F&B International Group admin' role

- Open 'Sales Order' Window and create a new entry
- Select 'F&B EspaƱa, S.A' in Organization
- In 'Warehouse' selector, click the glass icon
- Click in the dropdown arrow in location column, then you can notice that two
 checkboxes appears but with no description

An alternative way to reproduce it is to installed the attached diff. It will add two properties to the Product selector on the Lines subtab of the Sales Order window.
TagsNo tags attached.
Attached Filesdiff file icon 49826-reproducer.diff [^] (8,205 bytes) 2023-01-30 12:31 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
blocks feature request 0049375 newbcolorado Workflows adaptations for product price with exceptions. 

-  Notes
hgbot (developer)
2023-01-16 07:43

Merge Request created: [^]
hgbot (developer)
2023-01-30 13:05

Repository: [^]
Changeset: 048594b4942ac35c5bf52c0219fabb5871372ef7
Author: Augusto Mauch <>
Date: 30-01-2023 13:05:28
URL: [^]

Fixes ISSUE-49826: Merge branch 'fix/49826-foreign-key-selector'

M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/
hgbot (developer)
2023-01-30 13:05

Merge request merged: [^]

- Issue History
Date Modified Username Field Change
2022-07-18 11:14 jarmendariz New Issue
2022-07-18 11:14 jarmendariz Assigned To => Triage Platform Base
2022-07-18 11:14 jarmendariz Modules => Core
2022-07-18 11:14 jarmendariz Triggers an Emergency Pack => No
2022-07-18 11:19 jarmendariz Relationship added blocks 0049375
2022-07-23 17:50 cberner Assigned To Triage Platform Base => ablasco
2022-08-31 09:52 psanjuan Type defect => design defect
2023-01-04 14:19 AugustoMauch Assigned To ablasco => gonzalo_fernandez
2023-01-04 14:19 AugustoMauch Status new => scheduled
2023-01-09 11:45 alostale Description Updated View Revisions
2023-01-16 07:43 hgbot Note Added: 0145430
2023-01-30 12:31 AugustoMauch File Added: 49826-reproducer.diff
2023-01-30 12:31 AugustoMauch Steps to Reproduce Updated View Revisions
2023-01-30 13:05 hgbot Resolution open => fixed
2023-01-30 13:05 hgbot Status scheduled => resolved
2023-01-30 13:05 hgbot Fixed in Version => PR23Q2
2023-01-30 13:05 hgbot Note Added: 0146025
2023-01-30 13:05 hgbot Note Added: 0146026
2023-01-31 08:29 AugustoMauch Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker