web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Filter Group

(0) ShareShare
ReportReport
Posted on by

Hi Forum,

I have tried to understand about filter group but can't. So please any one can explain filter group in details. What filter group does actually? Why we use it and for what? Give suggestion with examples.

Thanks & Regards

Niraj Kumar

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mohana Yadav Profile Picture
    61,005 Super User 2025 Season 2 on at

    Please search for FilterGroup in below link for examples

    www.mibuso.com/howtoinfo.asp

  • Suggested answer
    Community Member Profile Picture
    on at
  • Suggested answer
    Rajasekhar@MS Profile Picture
    5,569 on at
  • mmv Profile Picture
    11,471 on at

    Hi,

    There are many links available on the FILTERGROUP.  You may check the below too:

    https://msdn.microsoft.com/en-us/library/dd338919.aspx

  • Community Member Profile Picture
    on at

    Thanks for your suggestion. It was really helpful for me......

  • Community Member Profile Picture
    on at

    Hi, Mohana

    thanks for your valuable answer but little more confusion with this code....

    Customer.RESET;

    Customer.SETCURRENTKEY("No.");

    Customer.SETRANGE("No.", '10000');

    Customer.FILTERGROUP(255);

    Customer.SETRANGE("No.", '50000');

    Customer.FILTERGROUP(0);

    Customer.FINDFIRST;

    MESSAGE('Filters: %1\First Customer: %2', Customer.GETFILTERS, Customer.Name);

    Actually why do we use  "FILTERGROUP(0)" and with other integer value with FILTERGROUP

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    23,118 on at

    If you go to the link : https://msdn.microsoft.com/en-us/library/dd338919.aspx?f=255&MSPPError=-2147217396

    and read the bottom table you will have your nanswer there.

  • Community Member Profile Picture
    on at

    Hi, Tharanga

    I studied all the links related to filtergroup but I am confused because, the task I have done with the help of filtergroup, the same task I did without filtergroup.Then my question is what is the use of filtergroup? Why we write code between two filtergroups, whereas without filtergroup we can do the same...please I am so confused and I always feel shame when it is asked in interview. So suggest me with best example so that I can understand it in easy way....

  • Verified answer
    Rajasekhar@MS Profile Picture
    5,569 on at

    Hi

    Refer the below link for the usage of filtergroup

    www.safaribooksonline.com/.../ch07s04.html

    if we apply the filtergroup the users will not be able to remove the filters applied using clearfilters.(ctrl+shift+A)

    Regards

    Rajasekhar.Y

  • Community Member Profile Picture
    on at

    Hi, Rajasekhar Y

    Your suggestion was very useful and the last line which you have written, removed my all confusion. So I appreciate your suggestion.....

    Thanks & Regards

    Niraj Kumar

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans