how to filter like 'Source Table View' ?

casanova

hi all
I've created filtering once user open pages
using setfilter
but user still can unfiltered it
how to do filtering something like SourceTableView, for example : WHERE(Salesperson Code=CONST(AB))
which means, user not allowed to unfiltered it

thx

mmperis8

Hello,

If you are doing the filters by code, use FILTERGROUP statement

casanova

mmperis8 wrote:

Hello,

If you are doing the filters by code, use FILTERGROUP statement

hi mmpreis,
my code is like this one below
but doesnt work

SETRANGE(Salesperson."Salesperson Code",'AB');
FILTERGROUP(2);

mmperis8

You have to change filter group before the setrange statement, and return filter group to 0 after, like this:

FILTERGROUP(2);
SETRANGE(Salesperson."Salesperson Code",'AB');
FILTERGROUP(0);

casanova

mmperis8 wrote:

You have to change filter group before the setrange statement, and return filter group to 0 after, like this:

FILTERGROUP(2);
SETRANGE(Salesperson."Salesperson Code",'AB');
FILTERGROUP(0);

mmperis8,
great
THX!!

:thumbsup: :thumbsup: :thumbsup: