[OLINGO-414] Cannot Filter on Navigation Property

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: V2 2.0.0
• Fix Version/s: V2 2.0.8
• Component/s: odata2-jpa
• Assignee: mibo
• Reporter: Simon Carroll
• Created: 21/Aug/14 15:46
• Updated: 05/Jul/17 06:29
• Resolved: 27/Nov/16 07:57

Description

We are receiving an error when we try to filter on a navigation property. In our solution we have a Notification entity and a User entity, we would like to retrieve a specific Notification but only if it is linked to the requesting user. This would involve an ODATA request which filters on both the UserId and the NotificationId. An example of the URL we are invoking is:

dspplatform.svc/Notifications?$filter=NotificationId%20eq%204%20and%20UserDetails/UserId%20eq%202

This returns the following error:
org.apache.olingo.odata2.core.edm.provider.EdmNavigationPropertyImplProv cannot be cast to org.apache.olingo.odata2.api.edm.EdmProperty

Can you please advise on how to perform filters on a Navigation property as we need this as part of our core functionality?

Issue Links

• is cloned by: OLINGO-1146 CLONE - Cannot Filter on Navigation Property
• is duplicated by: OLINGO-900 filter not working on navigational property In odata v2
• is duplicated by: OLINGO-517 Expand and filter bug
• is duplicated by: OLINGO-475 Filter on child entity is not working.
• is related to: OLINGO-1095 JPAQueryBuilder.normalizeMembers encounters issue when EmbedId
• is related to: OLINGO-178 How to apply filter on target entity