Is this using OData? V2 or V4?
Can you give specific examples? From what I understood from your question above even with childtable(pk), you will only get child table contents, not parent table contents.
Sorry for late reply. I am using odata V2.
Please find the above diagram 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'
how do i get results which satisfy both the filter and foreign key relationship?
That would be a bug, can log an issue?
we raised this defect when we were using jboss-eap-6.3 for our development.
We are using /jboss-eap-6.4/ in our higher environments - sit,cert, prod.
We observe that the patch is not their in this version, since the filter is not working.
How do i know if this version is having the patch? Please let me know the commands.
In my higher environments version.txt in /jboss-eap-6.4/ has the following info.
Red Hat JBoss Enterprise Application Platform - Version 6.4.0.GA
Red Hat JBoss Data Virtualization - Version 6.2.0
> In my higher environments version.txt in /jboss-eap-6.4/ has the following info.
You should expect to see the 6.2.x for a patched version. You should contact support to confirm what patch level you need for 6.1 and 6.2.