Automatically filtering records when user opens a form

david.weeks

Hello All,

I have used the table filter within SourceTableView to automatically apply a filter on the open field when the user opens the customer ledger entry table.

However, when they press SHOWALL button, I want all entries to be displayed including entries that are not open. But at the moment, pressing SHOW ALL just lists all open entries for all customers.

Ideas?

Thanks

david.weeks

Hi,

I have solved this problem by not using the sourcetableview.
I have used SETFILTER within the OnInit of the form.

However, and this is already part of Navision, when you press SHOWALL, it shows all records for all customers (i.e. as per usual).

Any way of keeping the customer filter when pressing Show All?

Thanks

Waldo

Try this:

Put the code below in a codeunit, and call it like cdu.fctSetFilter(Rec);

fctSetFilter(VAR prec: Record "Record Of Form")

WITH prec DO BEGIN
      FILTERGROUP(2);
      SETCURRENTKEY(field1,field2);
      SETRANGE(field1,'test1');
      SETRANGE(field2,'test2);
      FILTERGROUP(0);
END;

Tip: Read the C/SIDE help on FILTERGROUP, it explains a lot!

RobertMo

and it is not needed to have this code in cu, you can have your function on table/form or even without function. depends on where else you would like to apply your filtering. important part is between BEGIN and END