locked
odata query RRS feed

  • Question

  • How can I filter a look up property on the account entity to not include null values? I have a field on Account called Ultimate Parent that is a look up to another account record. I'd like to return all records where ultimate parent is not null. This doesn't filter them (below), and I can't seem to expand the Id field to check that for null:

    AccountSet?$filter=new_ultimateparent%20ne%20null

    Wednesday, February 19, 2014 9:36 PM

Answers

  • Hi

    Try this Ö

    https://servername/XRMServices/2011/OrganizationData.svc/AccountSet?$select=Name,new_ultimateparent&$filter=new_ultimateparent/Id%20ne%20(null)
    I am not sure, how your field new_ultimateparent actually is in crm. Ensure you have correct casing.

    • Marked as answer by GS7711175 Monday, February 24, 2014 2:24 PM
    Wednesday, February 19, 2014 9:53 PM