With the QueryCategory property we can execute a query object from a page (also available in Smartlists) by defining a query in AL; it is possible to declare with a comma separated list where the object can be used, in practice it is added to the list of objects published in the SmartList.
Source : Roberto Stefanetti Blog – Microsoft Dynamics 365 Business Central
Read more…
The Rules Pattern is a Design Pattern to simplify the complex business logic which is based on multiple if-else statements. Using this Design Pattern each if-else branch in the business logic is segregated into a separate rules and also the processing logic is separated from the rules.
This blog post is not really a troubleshooting guide (although there is a small TSG at the end). It is more like a brain dump of what I have seen over time and how I would approach a trouble shooting session. I have divided it into 6 sections:
In my last video, I asked if viewers wanted to see me create a Tic-Tac-Toe game in Microsoft Dynamics 365 Business Central. Lots of viewers wanted that.
Tic-Tac-Toe in AL is nothing new, Vjeko did it back in 2017 as a demo of the Javascript control addin, so for this to be a challenge, it should be done in pure AL without using Javascript for UI.
In the training I’ve done to some partners last week, when talking about performances I shared an example of an extension with 3 features that I think are not so well known but that have a significant impact on how your code performs, expecially on a SaaS environment. That extension used the following features:
-Partial record loading
-Temporary Tables
-QueryCategory
In this video, I look at how to use the base64 codeunit to transfer data in and out of Microsoft Dynamics 365 Business Central.
Run-AlPipeline is a new function in BcContainerHelper. It has been in preview for a number of releases while being worked on, and a number of partners have already tried to use it. My apologies for changing things under your feet, but to my defense – I did write that the function was in preview.