CODEWITHSUNDEEP
odata
GameBuilder
GameBuilder

Reputation: 1189

ODATA : Filter in parent and child table

I am trying to get the result from odata using filter in header table and child table.

Following is the ODATA URL not working.

ODATA Not working URL

Error i get is 

Could not find a property named 'State' on type 'ODataDemo.Supplier'

If you check the working URL , you can see the State field .

If i remove the and Supplier/State eq 'WA' from above the url works fine. Working

Please guide.

Regards

Prat

Upvotes: 0

Views: 1357

Answers (1)

iPirat
iPirat

Reputation: 2206

Try using Supplier/Address/State:

https://services.odata.org/OData/OData.svc/Products?$filter%20=%20ID%20eq%203%20and%20Supplier/Address/State%20eq%20%27WA%27%20&$expand%20=%20Supplier

Upvotes: 1

Related Questions