Tag: Development

Query Methods for Business Central AL Development

Query Methods for Business Central AL Development

Tonya Bricco-Meske, Microsoft MVPLeave a comment

Queries are powerful tools for data analysis within Business Central, allowing us to perform a range of calculations that help us aggregate and make sense of our data. To do this, we set a Method property on a chosen column within our query, which gives us a clear way to “manipulate” the data.

Among the built-in methods we have, there are several that work with numerical datatypes – like Decimal, Integer, Big Integer, or Duration – such as Sum, Average, Min, Max, and Count. There are even a few methods available to help us work with Dates in Business Central. This blog post will hopefully be a good demonstration of the different query methods available, and spark some ideas where you could skip expensive looping techniques in favor of leveraging queries. 😺Rogan says “don’t sleep on using Queries in your Business Central Development!”

Read More »
Live Share - VS Code Pair Programming

Live Share – VSCode Pair Programming

Tonya Bricco-Meske, Microsoft MVPLeave a comment

As a developer, we oftentimes participate in code reviews where we are either sharing our screen, or viewing someone else’s code. How hard is it to identify where some code needs to be changed, or it’s hard to follow someone navigating through their code.

Perhaps you are rubber duck debugging, and your code still isn’t making sense. That whole “it works in my Docker container, but not in the Sandbox”, and wouldn’t it be nice to debug WITH a co-worker? You can both set break points within the same code base, and debug within someone’s local Docker container.

Maybe you want to speed up development. One person is adding fields and pages, and someone else is adding some custom business logic, but it relies on those fields being created. We know that you need to add the related fields to the “sister tables” to the data flows through to all the related posted tables, but man, does that take some extra effort. You can share one person’s VS Code instance, and pair program!

If any of the above scenarios sound interesting to you, then you need to install the Live Share VS Code extension!

Read More »
Scheduled Performance Profiler in Business Central

Scheduled Performance Profiler in Business Central

Tonya Bricco-Meske, Microsoft MVPLeave a comment

Performance issues can be the bane of our existence, especially in the middle of a busy workweek. Not only do they slow users down, but they are frustrating to try and troubleshoot, and it’s oftentimes troublesome to schedule time *right now* when someone is experiencing issues. In this blog post we are going to add the Scheduled Performance Profiler as the new secret weapon in your troubleshooting toolbox, and dive into the insights available with the Performance Profiler.

Read More »