Dynamics Business Central / NAV Developer Digest - Vol. 531
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes using GitHub Copilot Coding Agent for problem resolution, four ways to calculate column totals, database locking in Business Central, and managing BC telemetry.
The Dynamics 365 Business Central community, consisting of developers, project managers, and consultants, collaborates across various platforms to share valuable insights. At ArcherPoint, we greatly value their dedication and expertise. To ensure widespread access to this technical knowledge, we created Developer Digest.
Using GitHub Copilot Coding Agent for problem resolution
Stefano Demiliani offers an intriguing example of assigning a software issue to the GitHub Copilot Coding Agent. The agent worked in the background to create an AL solution and proposed code changes to address the issue. It also provided a detailed description of the changes required to fix the problem, created new events, and assigned the code modifications for review.
Check out his description of his experiences by reading his blog, GitHub Copilot Coding Agent helps you stay strong on the bike…
Four ways to calculate column totals
An important task for developers is to calculate the sum of a table column. There are multiple ways to perform this calculation. But, as you might have expected, each has advantages and disadvantages.
Yun Zhu provides a description of each type of calculation, complete with advantages and disadvantages as well as coding examples for the following methods:
- Using AL repetitive statements (Loop)
- Using Record.CalcSums Method
- Using Query Object
- Using Flowfields
Learn more by reading his blog, Dynamics 365 Business Central: How to calculate the total (sum) of a column in a table (Four ways)?
Database locking in Business Central
Tri-state locking, RCSI (Read Committed Snapshot Isolation), and AL ReadIsolation have helped to streamline concurrency in BC. However, tri-state locking and Read Isolation principles are both applied to In-Transaction Single Reads while the transaction isolation level remains at its current platform default (Repeatable Read).
Duilio Tacconi breaks down the implications of Business Central’s use of Optimized Locking (or lack thereof), in his blog, Optimized Locking feature vs Dynamics 365 Business Central.
Managing BC telemetry
Waldo breaks down the main features of his free telemetry app for Business Central in his third post in this series. See what’s included in his blog, Handling Business Central Telemetry like a boss: iFacto Telemetry – Pt. 3.
Are you interested in Dynamics NAV and Business Central development? Check out our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint by Cherry Bekaert for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.