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

View Revisions: Issue #49826 All Revisions ] 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



Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker