-
1. Re: filter on child table not working
rareddy Aug 24, 2015 9:09 AM (in response to prashanthi1)Prashanthi,
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.
Ramesh..
-
2. Re: filter on child table not working
prashanthi1 Sep 1, 2015 11:40 AM (in response to rareddy)Hi Ramesh,
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?
Thanks,
Prashanthi
-
3. Re: filter on child table not working
rareddy Sep 2, 2015 8:50 AM (in response to prashanthi1)That would be a bug, can log an issue?
-
-
5. Re: filter on child table not working
prashanthi1 Jan 20, 2016 5:37 AM (in response to prashanthi1)Hi Ramesh,
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.
https://access.redhat.com/jbossnetwork/restricted/softwareDetail.html?softwareId=40621
How do i know if this version is having the patch? Please let me know the commands.
Thanks,
Prashanthi.
-
6. Re: filter on child table not working
prashanthi1 Jan 20, 2016 5:38 AM (in response to prashanthi1)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
-
7. Re: filter on child table not working
shawkins Jan 20, 2016 1:44 PM (in response to prashanthi1)> 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.