Open Page - with - Filters - visible to the user

(1) Share

Report

Posted on by SÖ-17061501-0

230

Hello Community,

i have got the following question.

I want the user to be able to open a page via click on a Field.

If he clicks on the Field i want the page for contacts to open.

However i am setting Filter via Set Range so only certain contacts should be shown to the user.

That is easy.

However i want the user to be able to see the Filter which i have entered and i want the user to be able to change the filter.

These should be possible if the user opens the page and wants to change the filter.

I have already found these functionalities in Business Central however i am not able to copy it.

What i want is this:

What i get instead:

This would be my latest try

                    ApplicationArea = All;
                    trigger OnDrillDown()
                    var
                        Contact: Record Contact;
                        ContactList: Page "Contact List";
                    begin
                        Contact.Reset();
                        Contact.SetRange("Reference Contact", Rec."Sell-to Contact No.");
                        Page.RunModal(Page::"Contact List", Contact)
                    end;

I have read these:

https://github.com/microsoft/AL/issues/6201

https://yzhums.com/5985/#toc1

Dear Community Please Help!

I have the same question (0)

All responses (5)

Answers (1)

Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi

Have you tried coding the OnLookup event, or duplicating the standard ContactList page?

BR

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (3)

Report
Hi, Below is an example of opening Item Ledger Entries, I hope it can give you some hints.

pageextension 50201 ItemListExt extends "Item List" { layout { modify(InventoryField) { trigger OnDrillDown() var ItemLedgerEntry: Record "Item Ledger Entry"; begin ItemLedgerEntry.Reset(); ItemLedgerEntry.SetRange("Item No.", Rec."No."); ItemLedgerEntry.SetRange("Entry Type", ItemLedgerEntry."Entry Type"::Purchase); if not ItemLedgerEntry.IsEmpty then Page.Run(Page::"Item Ledger Entries", ItemLedgerEntry); end; } } }

Thanks

ZHU

Was this reply helpful? Yes No
SÖ-17061501-0 230 on at

Like (2)

Report

@Yun ZHU

thanks for your post.

This seems to be the right way.

However, now i have another question.

I want to be able to choose an entry of this page and take the information and assign them

to the Field.

Now if i click on one entry i get directed to the card page.

and assign them here:

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

This requires using the function in the Page to pass the value in. Here is a simple example that I hope will give you some hints.

https://yzhums.com/51270/

And

https://yzhums.com/39193/

Thanks

ZHU

Was this reply helpful? Yes No
Verified answer

SÖ-17061501-0 230 on at

Like (2)

Report

@YUN ZHU @gdrenteria

Thank you for your replies.

I have found a solution through combination of different methods.

Was this reply helpful? Yes No