Dynamics NAV Web Client: Filters & FlowFilters on pages

As we all know, Microsoft stated that “Using Limit totals to is not supported. Use Filter on column instead” in Feature Limitations of the Microsoft Dynamics NAV Web Client.

We also know that this functionality is massively used  by accountant, among others. One of my customers said to me: I like the new web client but I missed my flowfilters.

Such a waste! RIP CTRL+F7 & SHIFT+F7 😥

TableFilters

If you also missed those two lovely buttons from Dynamics NAV 2009 (Classic Client) and older versions… Well, today we will resurrect them.

Today, I’ll show you how to combine those two powerful functions into one tiny powerful function (just like Goku and Vegeta’s fusion 😛 ; don’t mind if you don’t know Dragon Ball).

Enough bla bla bla. The new “Table Filters” looks like this in the Web Client. It also works on Windows Client:

TableFilters_Resurrection

The trick consists of a simple action “TableFilters” you can add to every page on your database. You do not need to modify or adapt the code to fit other pages based on different tables.

Here is the complete code:

TableFilters_code

Do not worry, I will not let you write the code again and try to guess the variables types 😉

Here is the Page 16 as an example tablefilter. I also included the code for NAV 2013 as it needed some rework.

Of course, I’ll let you enhance my “Table Filter” 😉

Hey Microsoft, could you include this (or something like this) in all pages for new NAV versions?

This blog is available also on Microsoft Dynamics NAV Community

 

Advertisements

3 thoughts on “Dynamics NAV Web Client: Filters & FlowFilters on pages

    • Hello Xhevat,

      I Updated the link. I also updated the fob because I noticed there was a missing comma.

      Besides, you need to know that I don’t handle fields CaptionClass in the page filter. So, instead of “DEPARTMENT CODE” you will see “Global Dimension 1 Code”.

      I hope this help !

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s