Dynamics Community Forum Thread Details

Odata Filter by related entity property

Hi,

I need to get all the ProductSpecificOrderSettingsV3 of ReleasedProductV2 with a specific VendorAccountNumber.

The linq query I use is:

var qr_1= from t in context.ProductSpecificOrderSettingsV3
where t.ReleasedProductV2.PrimaryVendorAccountNumber == "3401000185"
select t;

that is correctly translated in the request to the server >> ...../data/ProductSpecificOrderSettingsV3?$filter=ReleasedProductV2/PrimaryVendorAccountNumber eq '3401000185'

but I receive the error:

"message":"Instance property 'ReleasedProductV2' is not defined for type 'Dynamics.AX.Application.Services.OData.EntityExtensions.ProductSpecificOrderSettingV3_3b5b7c0f314e456cbba9c8e34bd4aaa1.InventProductSpecificOrderSettingsV3Entity'","type":"System.ArgumentException"

I'm doind somthing wrong or filtering an entity by a related one property is not possible?

Thank you,

Alberto Coletti

Quick Links