Filter on part page

Business Central/NAV Technical Forum
1

Hello,

I have create a new document page and it is copy of sales order (42) page. I wanted to apply a additional filter to page like follows. Please help me on this.

I would like to hide the particular resource line, I mean type = resource and No = 1000. So any other types with No = 1000 or any other any resource line with No <> 1000 should be visible

I am fine to hardcode the resource no in code or maintain in any setup table.

Thanks.

2

Can anyone please help me on this…

3

Hi, hope this will help.

pageextension 50100 SalesOrderSubformExt extends “Sales Order Subform”
{
trigger OnOpenPage()
begin
Rec.FilterGroup(0);
Rec.SetFilter(Type, ‘<>%1’, Rec.Type::Resource);
Rec.SetFilter(“No.”, ‘<>%1’, ‘KATHERINE’);
Rec.FilterGroup(100);
end;
}