Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Even though many of us are experienced developers, the FILTERGROUP record function isn't for each of us a well-known or understood concept. Because of this very reason the following question has been for years part of the quiz I start a course day with.
So get ready …
The default lookup page for MyTable is run by the following C/AL code:
When the page is displayed, the user applies the table filter 6000..6500. Which records will then be shown?
a. No records because the filter will read: (1000..5000)&(6000..6500)b. Records in the range 1000..5000 because the program ignores the filter applied by the userc. Records in the range 1000..6500 because the filter will read (1000..6500)d. Records in the range 6000..6500 because the filter applied by the user overrides the SETFILTER call
"OK ... a, b, c, or d?" ...
... I did ask the 13 Slovenian developers I was giving a NAV 2015 update course to the last couple of days. And yes, some knew, but most had a hard time with it.
Triggered by this question and the discussion following it, one of the attendants, Darko Grasic (he earns the credits), consulted the msdn help on FILTERGROUP and asked me about FILTERGROUP(-1).
Yep, FILTERGROUP(-1). Follow the link and see. Or just try the following code:
Rewriting the code somewhat so it opens a page the result looks like this (including my former MS colleague Hervé):
You get it?
So with FILTERGROUP(-1) we now have and OR filter that can spread several columns! Wow.
Business Applications communities