how to filter like 'Source Table View' ?

casanova
casanova Member Posts: 194
edited 2013-10-17 in NAV Three Tier
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

Answers

  • mmperis8
    mmperis8 Member Posts: 19
    Hello,

    If you are doing the filters by code, use FILTERGROUP statement
  • casanova
    casanova Member Posts: 194
    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
    mmperis8 Member Posts: 19
    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
    casanova Member Posts: 194
    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:

Categories