Dynamics NAV / Business Central Developer Digest - Vol 393
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central development and Dynamics NAV development. In Developer Digest Volume 393, you’ll learn about altering the sorting order in a Business Central Page Extension, everything you need to know about queries in Business Central, finding the Table ID in AL, working with AL-Go for GitHub Preview, using Microsoft Tye for Azure Functions Projects, setting up approval workflows in Business Central, and the latest nuggets from Erik Hougaard.
The Dynamics NAV and Business Central community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media…so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there?
So, the ArcherPoint Microsoft Dynamics NAV/BC Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV/BC experts and devotees around the world. We hope these insights will benefit you, too.
Altering the Sorting Order in a BC Page Extension
Kyle asks: “Is it possible to alter the sorting order by default with a Page Extension? I’d like Descending, but I haven’t figured out how to do that.”
Nikita provides: “Use this 🙂 just did this for a client in a Page Extension.”
trigger OnOpenPage()
begin
Rec.SetCurrentKey(“No.”);
Rec.Ascending(false);
end;
Everything You Need to Know About Queries in Business Central
The Business Central Geek has a recent post with everything you need to know about Query Objects in BC. What is it? How does it work? You’ll also learn how to create a query and see a sample query when you read this post.
Finding the Table ID in AL
Marije shares a useful tip on how to find the table ID from a variable, something that was quite challenging in the Navision days, but is very easy in AL. See Tip #70 | Get ID from Table.
Working with AL-Go for GitHub Preview
Freddy shares an important tip when working with Al-Go for GitHub Preview. You’ll get the new updates before they are released but may encounter unpublished artifacts. He explains why and provides an easy fix.
Using Microsoft Tye for Azure Functions Projects
For those of you working frequently with serverless architectures, especially with Azure functions, Stefano Demiliani introduces Microsoft Tye. Tye is an open-source project, a developer tool that makes development, testing, and deployment of microservices and distributed applications easier. Learn more in his post, Testing Multiple Azure Functions Apps with Microsoft Tye.
Setting Up Approval Workflows in Business Central
The BC Geek is back with another detailed post to walk you through what, why, setup, and posting of approval workflows in Microsoft Dynamics 365 Business Central.
The Latest Business Central Nuggets from Erik Hougaard
If you haven’t visited Hougaard’s site in a while, he’s been busy making new videos on everything from copy/paste code to Power Automate to getting a location fix in AL, and much more. If staying up to date on Business Central development is one of your objectives, I recommend bookmarking this site.
Interested in Dynamics NAV and/or Business Central development? Be sure to see our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.