locked
Outer joins in CRM Online with additional filters RRS feed

  • Question

  • I'm looking to create a FetchXml query that returns all accounts which don't have an active case.

    The link below shows how to achieve a similar thing but it only works for accounts which don't have a case at all. I need a small variation to this but whenever I add a filter for statecode it doesn't return the correct set of records, it returns all accounts that have a case which isn't active.

    https://msdn.microsoft.com/en-us/library/dn531006.aspx

    Is this possible?


    Pete

    Wednesday, September 2, 2015 10:00 AM