News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to add filter when...

Small and medium business | Business Central, N...

Suggested answer

How to add filter when opening page

(1) Share

Report

Report

Posted on by JonaVR

69

Hi,

How can I make clicking on the Qty. on Sales Order field open the Sales Line page and filter in ascending order by Ship Date?

Thanks.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 81,396 Super User 2025 Season 1 on at

Like (2)

Report

How to add filter when opening page

Hi, this is a Flowfield, we can't modify its formula directly unless you recreate a new field.

In addition, you can rewrite the logic of opening the page in the OnDrillDown Trigger of the page.

For example, the following is a method to prevent users from drilling into Flowfield. More details:

PS: Dynamics 365 Business Central: How to make some filters mandatory on the list page (users can not change or remove)

https://yzhums.com/8427/

Hope this helps.

Thanks.

ZHU
Suggested answer

Saurav.Dhyani 14,314 Super User 2025 Season 1 on at

Like (2)

Report
How to add filter when opening page

Hi,

Subscribe to OnOpenPage Event and setascending.

[EventSubscriber(ObjectType::Page, Page::"Sales Lines", 'OnOpenPageEvent', '', false, false)] local procedure SortSalesLines(var Rec: Record "Sales Line") begin Rec.SetAscending("Shipment Date", true); end;

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,120 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans