0031454: Not possible to filter by Attribute Set Value in Return From Customer pick/edit lines

Assigned to platform:

The problem seems to be related to the way the Entity Alias for the attributeSetValue column is defined, or with the assigned reference "PAttributte"

The column attributeSetValue is defined with an Entity Alias = attributeSetValue, which seems to be OK.

I have tried to modify it to iol.attributeSetValue (as in the left join), but without success.

Log:
org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'join_0.description' [select iol.id as id, iol.organization as organization, iol.client as client, iol.product as product, iol.uOM as uOM, iol.id as goodsShipmentLine, iol.movementQuantity as movementQuantity, iol.shipmentReceipt.businessPartner as businessPartner, iol.shipmentReceipt.documentNo as shipmentNumber, iol.shipmentReceipt.movementDate as movementDate, attributeSetValue as attributeSetValue, ( coalesce((select sum(ol.orderedQuantity) from OrderLine as ol left join ol.salesOrder as o where ol.goodsShipmentLine = iol and o.processed = true and o.documentStatus <> 'VO'), 0))*(-1) as returnQtyOtherRM, (case when (select ('Y') from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol) is null then false else true end) as obSelected, ( coalesce((select ol.orderedQuantity from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol),0))*(-1) as returned, (select ol.returnReason from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol) as returnReason, coalesce((select ol.tax from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol) , (select e.salesOrderLine.tax from MaterialMgmtShipmentInOutLine as e where e.id = iol)) as tax, (case when (select e.priceList.priceIncludesTax from Order as e where e.id = :salesOrderId) = true then coalesce((select ol.unitPrice from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol), (select e.salesOrderLine.grossUnitPrice from MaterialMgmtShipmentInOutLine as e where e.id = iol)) else coalesce((select ol.unitPrice from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol), (select e.salesOrderLine.unitPrice from MaterialMgmtShipmentInOutLine as e where e.id = iol)) end) as unitPrice, (select e.salesOrderLine.salesOrder.documentNo from MaterialMgmtShipmentInOutLine as e where e.id = iol) as orderNo FROM MaterialMgmtShipmentInOutLine as iol left join iol.attributeSetValue as attributeSetValue join iol.shipmentReceipt as io join io.documentType as dt where io.businessPartner.id = :businessPartnerId and dt.return = false and io.processed = true and io.documentStatus <> 'VO' and io.salesTransaction = true and (iol.movementQuantity+( coalesce((select sum(ol.orderedQuantity) from OrderLine as ol left join ol.salesOrder as o where ol.goodsShipmentLine = iol and o.processed = true and o.documentStatus <> 'VO'), 0)) <> 0) and (select iol.salesOrderLine.orderDiscount from MaterialMgmtShipmentInOutLine as e where e.id = iol) is null and iol.client.id in ('0', '23C59575B9CF467C9620760EB255B389') AND iol.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A') AND ( upper((COALESCE(to_char(join_0.description),''))) like upper(:alias_0) escape '|' ) ORDER BY obSelected desc, obSelected desc, io.movementDate desc, io.documentNo desc, iol.lineNo]

The automatically created HQL is wrong: it contains an alias "join_0", which seems to be a consequence of the reference "PAtrribute" used in the attributeSetValue column.

According to the documentation [1], this kind of foreign key references must mandatory use the Table reference. Not sure if that's possible here or not.

@Platform, please decide whether this is a design or a normal defect and the way to fix it.