Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045556ModulesDistribution Orderspublic2020-12-10 19:012022-02-01 08:05
ReporterAtulOpenbravo 
Assigned ToTriage Platform Base 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0045556: Grid filtering failed for HQL Query based table column in Distribution Order Issue window
DescriptionGrid 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 )) ]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Error45556.png (97,992) 2020-12-10 19:47
https://issues.openbravo.com/file_download.php?file_id=15151&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2020-12-10 19:01AtulOpenbravoNew Issue
2020-12-10 19:01AtulOpenbravoAssigned To => platform
2020-12-10 19:47AtulOpenbravoFile Added: Error45556.png
2022-02-01 08:05alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.