Save filter in a table

Willibald
Member Posts: 2
Hello,
is it possible to save a set of filters in a table, so you can reuse them later? Like in a report, where the user can select the needed fields from the fieldlist and set a filter for each field.
We have a table "Sales Order Overviews". Each user can setup Overviews as needed. A second table shows all Orders per Overview. It would be very helpfull to give the user the option to select different fields and set filters for that fields. At the moment the users have only a few filters, which can be set in the "Sales Oder Overviews" table. A functions uses this limited selection of filter to update the second table with the matching orders. But if we could set up a kind of filter list, we could easily filter on different fields. And it would be easy to transfer a filter list from one Overview to an other Overview.
We planing to update from 3.70 to NAV 2009 SP1, Classic Client.
Thanks for your help.
is it possible to save a set of filters in a table, so you can reuse them later? Like in a report, where the user can select the needed fields from the fieldlist and set a filter for each field.
We have a table "Sales Order Overviews". Each user can setup Overviews as needed. A second table shows all Orders per Overview. It would be very helpfull to give the user the option to select different fields and set filters for that fields. At the moment the users have only a few filters, which can be set in the "Sales Oder Overviews" table. A functions uses this limited selection of filter to update the second table with the matching orders. But if we could set up a kind of filter list, we could easily filter on different fields. And it would be easy to transfer a filter list from one Overview to an other Overview.
We planing to update from 3.70 to NAV 2009 SP1, Classic Client.
Thanks for your help.

0
Answers
-
You can do something similar standard NAV does for warehouse to get source docs. Please check form 5784 and 5786, i hope that will give you some direction how you want to implement your filters.0
-
We created custom filters like this:
viewtopic.php?f=23&t=45260
with something lke this you can create all kinds of custom filters we constantly use.
access them from a dropdown list.
you can add as many as you wish.
saving time from filtering one field at time.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions