Akash Murthy created OLINGO-1241: ------------------------------------ Summary: OData V4 How to filter nested properties Key: OLINGO-1241 URL: https://issues.apache.org/jira/browse/OLINGO-1241 Project: Olingo Issue Type: Question Reporter: Akash Murthy
I have an OData entity model whose service metadata document description is as follows: <EntityType Name="employers"> <Key> <PropertyRef Name="rwemployerId"/> </Key> <Property Name="rwemployerId" Type="Edm.String"/> <Property Name="name" Type="Edm.String"/> <Property Name="addresses" Type="Collection(odata.atlas.EmployerAddressModel)"/> <Property Name="partnerName" Type="Edm.String"/> <Property Name="partnerCode" Type="Edm.String"/> </EntityType> <ComplexType Name="EmployerAddressModel"> <Property Name="street1" Type="Edm.String"/> <Property Name="street2" Type="Edm.String"/> <Property Name="city" Type="Edm.String"/> <Property Name="state" Type="Edm.String"/> <Property Name="postalCode" Type="Edm.String"/> <Property Name="countryCode" Type="Edm.String"/> </ComplexType> So essentially, I have a parent entity called employers, which has a complex collection property called addresses whose type is EmployerAddressModel. I have implemented filtering of primitive types, based on the tutorial found here: [https://olingo.apache.org/doc/odata4/tutorials/sqo_f/tutorial_sqo_f.html] Currently, I can query by primitive type like so: api/employers?$filter=name eq 'Something' But what needs to be implemented to filter by 'city' property within the 'addresses' complex collection? How would the url need to be formed for such as query? Should it be something like this? api/employers?$filter=addresses/city eq 'CityName' or api/employers?$filter=addresses(1)/city eq 'CityName' This doesn't work at the moment, an answer to this would be greatly appreciated. Thanks and regards, Akash -- This message was sent by Atlassian JIRA (v7.6.3#76005)