If you’re using any hierarchies in your data, you’ve probably noticed the icon in your main grid views that you can click on to show the hierarchy view when records have a parent or children. It’s simple to work out if a record has a parent – just check if Continue Reading
SQL 4 CDS 1.0.9 Released!
I’ve just released SQL 4 CDS 1.0.9. Please update it when XrmToolBox prompts you to take advantage of these latest features:
FetchXML Multiple Links
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: