Help - How to change the default filter in Dynamics NAV 2009 RTC List Page?

(0) Share

Report

Posted on by kdubois

125

Hello Everyone,

Could someone please help me with changing the default filter in Dynamics NAV 2009 RTC list page? Please see the snapshot attached. Currently, Customer list's filter pane(Advanced Filter) always defaults to bill to customer no. but I would like to know how to change it to some other field. This default filter should be persistent so that it always defaults to whatever field is set when Dynamics Nav Client (RTC) is restarted.

Thanks in advance!!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Neville Foyn 4,320 on at

Like (0)

Report

Hi

You have 2 options here,

The system is always using the first column on the list view as the default filter, so if you move the Name to the first position this will be the filter displayed by default (Choose column, select it move up till it gets to the top) - this could be done in the designer so it becomes the default for every one

The second option is to add a bit of code to the open page section of the customer list that actually filters on something on the column, that will have the system default to that filter and display the filter (As below i am saying where the name is not blank)

SETFILTER(Name,'<>''''');

This will open the page with the filters showing the filter (And not showing customers where the name is blank (for example)) the user can then change the filter if they need to

Hopefully one of these options will be able to meet the requirement

Was this reply helpful? Yes No
kdubois 125 on at

Like (0)

Report

Thank You Neville, As you suggested the second option works for us because we don't want to change the order of column in a list page.

Thanks again for quick response

Was this reply helpful? Yes No
Neville Foyn 4,320 on at

Like (0)

Report

Happy to help

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

One disadvantage of the solution 2 above is that it actually filters the records who have no name.

If you do want to see all the records you can use filters like this:

SETFILTER( "Text/Code Field", '*' );

SETFILTER( "Number Field", '<>%1|%2', 0, 0);

SETFILTER( "Date Field", '<>%1|%2', 0D, 0D);

SETFILTER( "Option Field", '<>%1', 99 );

It will open the page and show the filter section with some odd filter values, but at least all records are shown. I think it would be nice to have a page property simular to the report property "Filter Request Fields" which will automaticaly show the entered fields in the filter section, without the need of setting a filter value.

Grz Edgar

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

MR.Neville Foyn

I want to use the Three or more filters

Like 1. Product Group Code

2. Item Catagory Code

how can do it.

Was this reply helpful? Yes No