0045556: Grid filtering failed for HQL Query based table column in Distribution Order Issue window

Description

Grid filtering failed for HQL Query based table column in Distribution Order Issue window, Reserved Stock Tab uses a HQL query based table, Reservation Stock uses a column M_Reservation_Stock_ID which is rs object (rs is Main from table alias) in HQL query and has Reference : TableDir

Problem:
rs.reservationStock.reservation.quantity should have been transformed as rs.reservation.quantity

There is no property reservationStock for rs object, rs itself is a reservationStock object.

Steps To Reproduce

- In AWO instance back office
- Make sure column for Window: Distribution Order Issue, Tab: Reserved Stock, Field: Reservation Stock i.e M_Reservation_Stock_ID is set as Allow Sorting and Allow Filtering as Yes
- Login in with AWO-QA admin role
- Naivgate to Distribution Order Issue window, clear filters and select record with document no 1000123
- Navigate to Lines Tab, select record for Product : Apple
- Navigate to Reserved Stock Tab.
- Apply some text in Reservation Stock field filter. Click "Refresh the current data from database"
- Error is shown in the Message box as:
Error
org.hibernate.QueryException: could not resolve property: reservationStock of: MaterialMgmtReservationStock
[select rs.id, rs as M_Reservation_Stock_ID, rs.storageBin as M_Locator, rs.attributeSetValue as M_Attributesetinstance,
rs.quantity as Quantity, rs.released as ReleasedQty, rs.allocated as IsAllocated, r.obdoDistorderline as obdoDistorderline,
r.product as M_Product_ID
from MaterialMgmtReservationStock rs
join rs.reservation r where rs.client.id in ('0', :clientId)
AND rs.organization.id in ( :organizations )
AND (( upper((((rs.reservationStock.reservation.product.name) || ' - '
|| COALESCE(to_char(rs.reservationStock.reservation.quantity),'')) || ' - ' ||
COALESCE(to_char(rs.reservationStock.quantity),'') || ' - ' ||
COALESCE(to_char(rs.reservationStock.allocated),'')))
like upper(:alias_0) escape '|' and r.obdoDistorderline.id = :alias_1 )) ]

Issue History
Date Modified	Username	Field	Change
2020-12-10 19:01	AtulOpenbravo	New Issue
2020-12-10 19:01	AtulOpenbravo	Assigned To	=> platform
2020-12-10 19:47	AtulOpenbravo	File Added: Error45556.png
2022-02-01 08:05	alostale	Assigned To	platform => Triage Platform Base

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.