Business Central Execute Queries from Pages

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 in Business Central – AL Language

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.

Source : msnJournals
Read more…

Tic-Tac-Toe in 98% pure AL

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.

Source : Hougaard.com
Read more…

Dynamics 365 Business Central: new features for performant code

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

Source : Stefano Demiliani
Read more…