Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0049826 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| design defect | [Openbravo ERP] A. Platform | major | have not tried | 2022-07-18 11:14 | 2023-01-31 08:29 | |||
| Reporter | jarmendariz | View Status | public | |||||
| Assigned To | gonzalo_fernandez | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | PR23Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | merged | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0049826: Foreign key selector within Custom HQL selector grid does not show proper values | |||||||
| Description | In 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. https://openbravo.atlassian.net/browse/RM-2514 [^] | |||||||
| 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 w.id as id, w.name as name, w.locationAddress as location from Warehouse w where @additional_filters@ and w.active=true - 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  49826-reproducer.diff [^] (8,205 bytes) 2023-01-30 12:31 [Show Content]
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0145430) hgbot (developer) 2023-01-16 07:43 |
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/809 [^] |
|
(0146025) hgbot (developer) 2023-01-30 13:05 |
Repository: https://gitlab.com/openbravo/product/openbravo [^] Changeset: 048594b4942ac35c5bf52c0219fabb5871372ef7 Author: Augusto Mauch <augusto.mauch@openbravo.com> Date: 30-01-2023 13:05:28 URL: https://gitlab.com/openbravo/product/openbravo/-/commit/048594b4942ac35c5bf52c0219fabb5871372ef7 [^] Fixes ISSUE-49826: Merge branch 'fix/49826-foreign-key-selector' --- M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java --- |
|
(0146026) hgbot (developer) 2023-01-30 13:05 |
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/809 [^] |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | Merge Request Status | => open |
| 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 | Merge Request Status | open => merged |
| 2023-01-30 13:05 | hgbot | Note Added: 0146026 | |
| 2023-01-31 08:29 | AugustoMauch | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |