[teiid-issues] [JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

[Juraj Duráni (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Juraj Duráni reopened TEIID-4044:
---------------------------------


This is not resolved in ER3. Note that TEIID-4064 is resolved, but this one not. So I expected this to be no more duplicate of TEIID-4064.

> OData ignores entities with empty list of related entities if $filter is applied to expanded entities
> -----------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-4044
>                 URL: https://issues.jboss.org/browse/TEIID-4044
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: OData
>            Reporter: Juraj Duráni
>            Assignee: Ramesh Reddy
>
> If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities.
> *Example:*
> *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Orders_FK0($filter=place%20eq%20%27town%27)
> *Result:* OData returns only 2 customers (both have at least one order with place "town")
> *Expectation:* OData should return all 4 customers (two of them should have empty list of orders)



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)