Fetch XML limitations

There are some limitations which I've come accross which are hopefully MS will change for future releases.

• You cant specify left outer join, i.e Show me all Accounts without an Activity.
• Group/Sum isnt supported i.e Select Account, count(accountid), sum(estimated value) from FilteredAccount Group by Account

If these are show stoppers then you will need to look at one of the following alternatives

• Move to CRM On Premise
• Create a plugin to store a date field on the record of the last activity etc.
• Retrieve data using a webservice to store the data locally and then query that instead

Let me know if you find anymore that I havent listed here.