One common pattern of queries I see about FetchXML is how to write queries to ask two different questions about the same related entity. For example: Invoices that include product A AND product B? Contacts that have pending emails AND no sent emails? Visits that have a page view of Continue Reading
SQL 4 CDS 1.0.6 Released!
I’m very pleased to announce the release of SQL 4 CDS version 1.0.6! Please update your existing versions in XrmToolBox to get some great new features…
Inside FetchXML pt 6 – datetime grouping
Last time I looked at aggregates, but unforgivably I missed out how to apply grouping to date/time attributes: