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.
Overview | Guided Tour | Free Trial
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All 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