Project:
| View Revisions: Issue #49826 | [ Back to Issue ] | ||
| Summary | 0049826: Foreign key selector within Custom HQL selector grid does not show proper values | ||
| Revision | 2023-01-30 12:31 by AugustoMauch | ||
| 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. |
||
| Revision | 2023-01-30 12:31 by AugustoMauch | ||
| 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 |
||
| Revision | 2023-01-09 11:45 by alostale | ||
| 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 [^] |
||
| Revision | 2023-01-04 14:19 by alostale | ||
| 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. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |