ArcherPoint Dynamics NAV Developer Digest - vol 267

ArcherPoint Dynamics NAV Developer Digest - vol 267

The NAV 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 Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.

Using the FILTERGROUP Function

Suresh shares this handy tip: “To apply an OR filter between the columns, you can use the FILTERGROUP function. Below is the example, which finds all customers where the Customer Name or Contact Name contains the string John. This example requires that you create the following variable in the C/AL Globals window:

Customer.FILTERGROUP := -1;  

SearchString := ‘@*John*’;  

Customer.SETFILTER(Customer.Name, SearchString);  

Customer.SETFILTER(Customer.Contact, SearchString);  

Todd is grateful: “Thanks for posting! Never knew you could do this. I needed it to filter at OnOpenPage(). There is a slight wrinkle with pages, so I’m posting a link I found on FILTERGROUP(-1). It’s old but still relevant. Also, a thanks to Kyle for reminding me of the post.”

Dynamics NAV and Business Central Cumulative Updates for October 2019

Pavithra keeps us in the know with links to the latest cumulative updates for Dynamics NAV and Business Central: “Below are the links for downloading the Cumulative Update for the month of October 2019:

Azure Container Registry Adds Teleportation

In this post by Steve Lasker, he talks about Project Teleport and gives examples of teleportation performance. Read more at Azure Container Registry Adds Teleportation.

Use PowerShell to Find Events in the Event Log

Kyle shares one of his infamous: “Developer Tip of the Day: You can use PowerShell to find events in the event log: 

$Events = Get-EventLog -LogName application -Newest 100 

$Events | Select-String -InputObject {$_.message} -Pattern “failed” 

Git 2.24 Now Available

Kyle shares that the new release, Git 2.24 has been released. The release notes are fairly extensive and include improvements to UI, workflows, features, performance, internal implementation, and development support.


If you are interested in Dynamics NAV and Business Central development, be sure to see our collection of NAV/BC Development Blogs.

Read the “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.

Trending Posts

Stay Informed

Choose Your Preferences
First Name
Last Name
Subscription Options
Your Privacy is Guaranteed