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:
- Cumulative Update 05 for Microsoft Dynamics 365 BC 14 on premises (Application Build 36463, Platform Build 36457) Download
- Cumulative Update 012 for Microsoft Dynamics 365 BC 13 on premises (Application Build 36481, Platform Build 36446) Download
- Cumulative Update 22 for Microsoft Dynamics NAV 2018 (Build 36462) Download
- Cumulative Update 35 for Microsoft Dynamics NAV 2017 (Build 30033) Download
- Cumulative Update 48 for Microsoft Dynamics NAV 2016 (Build 51590) Download
- Cumulative Update 60 for Microsoft Dynamics NAV 2015 (Build 51584) Download
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.