One great option in FetchXML is to filter dates using a relative filter such as “this week”, “older than 2 years” etc. This is particularly helpful when you build a view, as it will automatically build the date criteria each time so your view is always up to date.
MSDyn365 Internals: Async Record Merging
Matt Beard & I spent some time investigating the new asynchronous merging functionality today and how it impacts Data8 Duplicare (it doesn’t, Duplicare continues to work as normal). If you haven’t seen this already, when you merge two records you’ll now see the message: The selected records will be merged Continue Reading
CDS T-SQL Performance
I wrote a post a while ago looking at the performance of the T-SQL endpoint compared to using FetchXML. Now I’ve got a better understanding of how it works, I wanted to check if the same performance considerations I’ve previously encountered when working with the filtered views on-premise still apply.
MSDyn365 Internals: T-SQL Endpoint
Disclaimer: the details in this post are based on the best guesses I’ve been able to make about how this works, which are derived from the behaviour I’ve seen while using it. I don’t have any official information on any of this, so use at your own risk!
PCF Dataset Control – Lookup Values
After getting over my initial authentication problems, my next adventure with PCF was to show some details from a lookup field in a dataset-bound control. With a dataset control, the manifest file can contain mappings for the attributes in the dataset that will be shown in the control, e.g.
PCF NuGet authentication error
After working with PCF during the initial private preview, I haven’t had a chance to use it in anger. Until today. And it didn’t go smoothly. It started well. I installed the CLI tooling, got a new template control ready to go with pac pcf init and connected to CDS Continue Reading
SQL 4 CDS 2.2.0 released
I’m pleased to release SQL 4 CDS 2.2.0 with two main improvements:
Column Comparisons in FetchXML
I was very pleased today to see a new feature in FetchXML – column comparisons! This allows us to build queries that compares the values in one column against those in another. Previously we’ve only been able to compare a column against a constant value.
D365 Posts Bot Released!
I’m very pleased to release D365 Posts Bot today! This is the finished article from my earlier series of blog posts on creating a bot to link posts from D365 through to Teams and back again.
Creating a bot pt. 8 – Handling Replies
Now we’ve got our bot sending out notifications, we want to be able to handle a reply from the user and add it back into D365 as a new post. The adaptive card notification lets the user reply via an embedded form. This makes it nice and neat. When the Continue Reading