Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
V2 2.0.10
-
None
-
None
Description
Olingo JPA fails for the following query -
$orderby=FreightOrder_Informations/CreationDateTime asc&$filter=(EventReportingStatus ne '00' and EventReportingStatus ne '' and EventReportingStatus ne '04' and EventReportingStatus ne '10' and CurrentEventOrdinalNumber ne 0) and (EventReportingStatus eq '01' or EventReportingStatus eq '02' or EventReportingStatus eq '03') and (FreightOrder_Informations/CreationDateTime ge '2021-01-06T18:30:00.000Z' and FreightOrder_Informations/CreationDateTime le '2021-01-07T18:29:59.999Z')&$select=OrderingPartyName,EventReportingStatus,DriverOneName,CurrentEventCode,PlannedEventDateTimeUi,ExpectedEventDateTimeUi,FreightOrder_Informations/CreationDateTime,FreightOrderGuid, CurrentEventGuid, OrderingPartyName, EventReportingStatus, DriverOneName, DriverTwoName, CurrentEventCode, PlateNumberCountryCode, PlateNumber, IsDelayed, ExpectedEventDelayDuration, FreightOrderId, CurrentEventLocationCity, CurrentEventOrdinalNumber, NumberOfPlannedEvents, NumberOfSkippedEvents, PlannedDateTimeOfSkippedEvent, PlannedEventDateTime, PlannedEventDateTimeUi, ExpectedEventDateTimeUi, CurrentEventLocationTimeZone, Version, DepartureDate, DepartureLocationCity, ArrivalLocationCity, FreightOrder_Informations/CreationDateTimeUi&$expand=FreightOrder_Informations
with
SAP DBTech JDBC: [260]: invalid column name: not included in SELECT DISTINCT column list: INFORMATIO1_.CreationDateTime: line 1 col 4941 (at pos 4940)
whereas the follwoing queries are successful -
1. Containing orderby for expanded table's attribute
$orderby=FreightOrder_Informations/CreationDateTime asc&$expand=FreightOrder_Informations
2. Containing filter for expanded table's attribute
$filter=FreightOrder_Informations/CreationDateTime ge '2021-01-06T18:30:00.000Z'&$expand=FreightOrder_Informations