Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Permanent Filters On a Page in Nav 2016
omyvadiya
Member Posts: 124
Hi,
I am trying to filter a Lookup of a Page via writing code on OnLookup trigger of the Field, its working fine, i.e; when the page is opened, it opens with the filtered data, but here the problem is user can clear filters.
Is there any way to have permanent filters whenever the page is opened.
For Eg: I want to open Item Ledger Entry Page with filter of
1. ILERec.SETRANGE("Item No.","No.");
2. IF UserSetupRec.GET(USERID) THEN;
ILERec.SETRANGE("Location Code",UserSetupRec."Location Code");
A workaround i think is that, i have to somehow remove the clear filter option from the Page.
Thanks in Advance.
I am trying to filter a Lookup of a Page via writing code on OnLookup trigger of the Field, its working fine, i.e; when the page is opened, it opens with the filtered data, but here the problem is user can clear filters.
Is there any way to have permanent filters whenever the page is opened.
For Eg: I want to open Item Ledger Entry Page with filter of
1. ILERec.SETRANGE("Item No.","No.");
2. IF UserSetupRec.GET(USERID) THEN;
ILERec.SETRANGE("Location Code",UserSetupRec."Location Code");
A workaround i think is that, i have to somehow remove the clear filter option from the Page.
Thanks in Advance.
0
Best Answer
-
Options
Duikmeester
Member Posts: 304
Try adding following line, Presuming the Rec = Item table:ILERec.FILTERGROUP(2); ILERec.SETRANGE("Item No.","No."); IF UserSetupRec.GET(USERID) THEN; ILERec.SETRANGE("Location Code",UserSetupRec."Location Code"); SETRANGE("Location Filter",UserSetupRec."Location Code"); //<<< ILERec.FILTERGROUP(0);
Better would be to add it in OnOpenPage or something like that. But this works also after OnLookup.5
Answers
ILERec.FILTERGROUP(2); ILERec.SETRANGE("Item No.","No."); IF UserSetupRec.GET(USERID) THEN; ILERec.SETRANGE("Location Code",UserSetupRec."Location Code"); ILERec.FILTERGROUP(0);Thanks its working
But, i have a problem, that the lookup is showing the value as 0, if it has some value too. PFA.
I know, it has to somehow work with Flowfield, any suggestions, how can i achieve it.
Requirement- If there is any inventory at the location defined in Usersetup.Location code, then the count of the that inventory must show and on lookup the list of the same must show.
Thanks in Advance
ILERec.FILTERGROUP(2); ILERec.SETRANGE("Item No.","No."); IF UserSetupRec.GET(USERID) THEN; ILERec.SETRANGE("Location Code",UserSetupRec."Location Code"); SETRANGE("Location Filter",UserSetupRec."Location Code"); //<<< ILERec.FILTERGROUP(0);Better would be to add it in OnOpenPage or something like that. But this works also after OnLookup.
The count of inventory is still 0, on lookup it is opening with correct location filter although.
Any idea about flowfilters?