Dynamics Community Forum Thread Details

Pre-define value for Filter

Hi,

I want to display dynamically the predefined value of the customer number on the filter of the page Item Ledger Entries by an page extension from Customer Card.

I have done the button and the filter but i can't display my value.

It works when it's a static value.

Can someone help me ?

There is my code and some exemple of my issue.

trigger OnAction()

                var
                    varFilterPageBuilder: FilterPageBuilder;
                    ItemLedgerEntry: Record "Item Ledger Entry";
                    MyCustomer: Record Customer;
                begin
                    varFilterPageBuilder.AddTable('Ecriture Comptables Article Table', ItemLedgerEntry.RecordId.TableNo);
                    varFilterPageBuilder.AddFieldNo('Ecriture Comptables Article Table', ItemLedgerEntry.FieldNo("Source No."), MyCustomer."No.");
                    varFilterPageBuilder.PageCaption := 'Ecritures Comptables Article Filtre';
                    if varFilterPageBuilder.RunModal() then begin
                        ItemLedgerEntry.SetView(varFilterPageBuilder.GetView('Ecriture Comptables Article Table'));
                        Page.Run(Page::"Item Ledger Entries", ItemLedgerEntry);
                    end;
                end;

Result to: 2023_2D00_01_2D00_12-10_5F00_10_5F00_43_2D00_Modifier-_2D00_-Fiche-client-_2D00_-Dynamics-365-Business-Central-_1420_-Mozilla-Firefox.png

varFilterPageBuilder.AddFieldNo('Ecriture Comptables Article Table', ItemLedgerEntry.FieldNo("Source No."), 'Test');

But when we put static value it result to: 2023_2D00_01_2D00_12-10_5F00_10_5F00_21_2D00_Modifier-_2D00_-Fiche-client-_2D00_-Dynamics-365-Business-Central-_1420_-Mozilla-Firefox.png