[
https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin...
]
Prashanthi Kairuppala commented on TEIID-3671:
----------------------------------------------
Hi [~blafond],
Please find the below sql statements.
For sales table-
SELECT
OracleConn.SALES_MAN.SM_ID AS ID, OracleConn.SALES_MAN.FIRST_NAME,
OracleConn.SALES_MAN.LAST_NAME
FROM
OracleConn.SALES_MAN
For sales_uk table-
SELECT
OracleConn.UK_SALE.SALE_ID, OracleConn.UK_SALE.DISCOUNT, OracleConn.UK_SALE.TYPE,
OracleConn.UK_SALE.PRICE, OracleConn.UK_SALE.SM_ID AS ID
FROM
OracleConn.UK_SALE
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
Priority: Critical
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.3.15#6346)