You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@olingo.apache.org by "Saurav Sahu (Jira)" <ji...@apache.org> on 2021/05/13 05:49:00 UTC
[jira] [Created] (OLINGO-1528) Olingo JPA fails on orderby and
filter of expanded table
Saurav Sahu created OLINGO-1528:
-----------------------------------
Summary: Olingo JPA fails on orderby and filter of expanded table
Key: OLINGO-1528
URL: https://issues.apache.org/jira/browse/OLINGO-1528
Project: Olingo
Issue Type: Bug
Components: odata2-jpa
Affects Versions: V2 2.0.10
Reporter: Saurav Sahu
Olingo JPA fails for the following query -
$orderby=FreightOrder_Informations/CreationDateTime asc&$filter=FreightOrder_Informations/CreationDateTime ge '2021-01-06T18:30:00.000Z'&$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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)