[teiid-issues] [JBoss JIRA] (TEIID-3671) filter on child table not working

[Prashanthi Kairuppala (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13107499#comment-13107499 ] 

Prashanthi Kairuppala commented on TEIID-3671:
----------------------------------------------

Hi [~shawkins],

any work around to achieve this until the next update is released?

Thanks,
Prashanthi.


> filter on child table not working
> ---------------------------------
>
>                 Key: TEIID-3671
>                 URL: https://issues.jboss.org/browse/TEIID-3671
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>            Reporter: Prashanthi Kairuppala
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 8.12, 8.11.4
>
>         Attachments: parent_childTables.PNG
>
>
>  
> Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json,  i get the results from sales_uk table which are having id=13.
>  
> Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'
>  



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