Filter OpportunityFileCollection by Opportunity using ODATA

Hi,

I'm trying to get a list of OpportunityFile associated with an OpportunityId and it's seems it's not possible using ODATA.

1. If I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… I'm getting a "Not Implemented" exception

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<script/>
<code>4
Not Implemented
Not Implemented

System.Data.Services.DataServiceException
at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)

 at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService, IODataResponseMessage responseMessage)

 at System.Data.Services.DataService`1.HandleRequest()
Method 'SelectMany' not supported

System.NotSupportedException
at Terrasoft.Core.Entities.EntityQueryProvider.VisitMethodCall(MethodCallExpression node)

 at Terrasoft.Core.Entities.EntityQueryProvider.Build(Expression expression)

 at Terrasoft.Core.Entities.EntityQueryProvider.LoadEntityCollection(Expression expression)

 at Terrasoft.Core.Entities.EntityQueryProvider.ExecuteEnumerable(Type elementType, Expression expression)

 at Terrasoft.Core.Entities.EntityQuery`1.GetEnumerator()

 at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)

2. If I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… eq guid'e14b9eb7-99ff-43a6-bf26-a60b23b3ec12') I'm getting the following exception:

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<script/>
<code>1
Collection item with name OpportunityId not found.
Collection item with name OpportunityId not found.

Terrasoft.Common.ItemNotFoundException
at Terrasoft.Core.Entities.EntitySchema.GetSchemaColumnByPath(String columnPath)

 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateExpression(Expression node)

 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateSimpleFilter(BinaryExpression binary)

 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateFilter(Expression node)

 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.BuildBlock(MethodCallExpression node)

 at Terrasoft.Core.Entities.EntityQueryProvider.VisitMethodCall(MethodCallExpression node)

 at Terrasoft.Core.Entities.EntityQueryProvider.Build(Expression expression)

 at Terrasoft.Core.Entities.EntityQueryProvider.LoadEntityCollection(Expression expression)

 at Terrasoft.Core.Entities.EntityQueryProvider.ExecuteEnumerable(Type elementType, Expression expression)

 at Terrasoft.Core.Entities.EntityQuery`1.GetEnumerator()

 at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)

 at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService, IODataResponseMessage responseMessage)

 at System.Data.Services.DataService`1.HandleRequest()

3. Also, if I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… eq guid'b3427cc4-3b20-4c16-8d2a-058ada7e7631') I'm getting a different error.

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<script/>
<code>4
Syntax error at position 1.
Syntax error at position 1.

System.Data.Services.DataServiceException
at System.Data.Services.Parsing.ExpressionLexer.ValidateToken(TokenId t)

 at System.Data.Services.Parsing.ExpressionLexer.ReadDottedIdentifier(Boolean allowEndWithDotStar)

 at System.Data.Services.RequestQueryProcessor.ReadExpandOrSelect(String value, Boolean select, IDataService dataService)

 at System.Data.Services.RequestQueryProcessor.ProcessSelect()

 at System.Data.Services.RequestQueryProcessor.ProcessQuery()

 at System.Data.Services.RequestQueryProcessor.ProcessQuery(IDataService service, RequestDescription description)

 at System.Data.Services.RequestUriProcessor.ProcessRequestUri(Uri absoluteRequestUri, IDataService service, Boolean internalQuery)

 at System.Data.Services.DataService`1.HandleRequest()

It seems the filtering is not working on associated collection entities. Do you have any ideas?

Regards,

Radu