How can I abolish or cancel a Filter

Business Central/NAV Developers Forum
1

Hi, I put with .SETFILTER an Filter in a Report. How can I cancel this Filter? Thanks for your support. Buble

2

To “set” filter SETFILTER(Field,FilterString,FilterParam1,FilterParam2,…) To “clear” filter SETFILTER(Field) Same thing with SETRANGE set: SETRANGE(Field,From,To) clear: SETRANGE(Field) regads Bostjan

3

You can also use the RESET command which will remove all filters on the table. See the online Help - C/SIDE Reference Guide - Index. Andy

4

quote:

Originally posted by Andy Malkin
You can also use the RESET command which will remove all filters on the table. See the online Help - C/SIDE Reference Guide - Index. Andy

RESET Use this function to remove all filters, including any special filters set by MARKEDONLY, and changes the current key to the primary key. The system also removes any marks on the record and clears any C/AL variables on the record. Copy & Pase form Help. Reset also “resets” current key, removes marks,… If you want only to clear filers than is maybe not using RESET. regads Bostjan