FILTERGROUP and RUNMODAL

Belias

hi everyone, i have a little problem with filtergroup...i can't get it work using this code:

CLEAR(TBPTSDescr);
CLEAR(FRMPTSDescr);
TBPTSDescr.FILTERGROUP(10);
IF "Phase Code" <> '' THEN
  TBPTSDescr.SETRANGE(Phase,"Phase Code");
IF "Task Code" <> '' THEN
  TBPTSDescr.SETRANGE(Task,"Task Code");
IF "Step Code" <> '' THEN
  TBPTSDescr.SETRANGE(Step,"Step Code");
FRMPTSDescr.SETTABLEVIEW(TBPTSDescr);
FRMPTSDescr.SETRECORD(TBPTSDescr);
FRMPTSDescr.RUNMODAL;
TBPTSDescr.FILTERGROUP(0);

thanks in advance

Yaroslav_Gaponov

Hi

For form need use group 2 - command TBPTSDescr.FILTERGROUP(2);

CLEAR(TBPTSDescr);
CLEAR(FRMPTSDescr);
TBPTSDescr.FILTERGROUP(2);
IF "Phase Code" <> '' THEN
  TBPTSDescr.SETRANGE(Phase,"Phase Code");
IF "Task Code" <> '' THEN
  TBPTSDescr.SETRANGE(Task,"Task Code");
IF "Step Code" <> '' THEN
  TBPTSDescr.SETRANGE(Step,"Step Code");
TBPTSDescr.FILTERGROUP(0);
...
FRMPTSDescr.RUNMODAL;

Belias

Yaroslav Gaponov wrote:

Hi

For form need use group 2 - command TBPTSDescr.FILTERGROUP(2);

:-k this is not true...you can use every number for filtergroups...it's not compulsory (and also not recommended) to use no.2 filtergroup, because MS use this group and you can interfere with it

Yaroslav_Gaponov

Hi

Yes You can use any group but for forms only 2

From help:
2 Form Used for the filtering actions that result from the SETTABLEVIEW function; from the SourceTableView property; and from the DataItemTableView property.

Belias

I extracted this directly from the online help...

This means that a filter set in a group different from FILTERGROUP 0 cannot be changed by a user that uses a filter dialog to set a filter. If, for example, a filter has been set on customer numbers 1000..2000 in group 4, the user can set a filter that delimits this selection further, but cannot widen it to include customer numbers outside the range 1000..2000.

It is possible to use one of the internally used groups from C/AL. If you do this, keep in mind that in this way, you will replace the filter that C/SIDE assumes is in this group. If, for example, you use FILTERGROUP 4 in a form, you will replace the filtering that is actually the result of applying the SubFormLink property. This could seriously alter the way forms and subforms interact.

Yaroslav_Gaponov

Yes
You right
Sorry ](*,)

Try this

CLEAR(TBPTSDescr);
CLEAR(FRMPTSDescr);
TBPTSDescr.FILTERGROUP(10);
IF "Phase Code" <> '' THEN
  TBPTSDescr.SETRANGE(Phase,"Phase Code");
IF "Task Code" <> '' THEN
  TBPTSDescr.SETRANGE(Task,"Task Code");
IF "Step Code" <> '' THEN
  TBPTSDescr.SETRANGE(Step,"Step Code");
TBPTSDescr.FILTERGROUP(0);
FRMPTSDescr.SETTABLEVIEW(TBPTSDescr);
FRMPTSDescr.RUNMODAL;

Belias

no problem, because
yes, it works! thank you!
but why? :-k

Yaroslav_Gaponov

Likely NAV make same code

CurrGroup := rec.FILTERGROUP;
for i := 0 to MaxGroup do
  if i <> CurrGroup then SetHideFilter()
    else SetFilter();

Belias

Yaroslav Gaponov wrote:

Likely NAV make same code

CurrGroup := rec.FILTERGROUP;
for i := 0 to MaxGroup do
  if i <> CurrGroup then SetHideFilter()
    else SetFilter();

:shock: where's this code? i can't understand it...
anyway...solved!

kine

It means that user can see filters in current filtergroup.If you didn't set the filtergroup back to 0, user can see filters in filter group 8 or 2 or another one you used last time... it is good practice to set it back to 0 because that...

Belias

ok, and where i can find this code in std NAV?

kine

Belias wrote:

ok, and where i can find this code in std NAV?

Nowhere... it was only example how it works "inside" the C/Side... ;-)