Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

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
Powered by Mantis Bugtracker