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.


    Is this possible?


    Wednesday, September 2, 2015 10:00 AM