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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0049826

Openbravo ERP

A. Platform

public

2022-07-18 11:14

2023-01-31 08:29

Reporter

jarmendariz

Assigned To

gonzalo_fernandez

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

PR23Q2

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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.

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

blocks

feature request

0049375

new

bcolorado

Workflows adaptations for product price with exceptions.

Attached Files