Skip to main content

Notifications

Announcements

No record found.

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

How to display records on a new page based on Header and LIne

(0) ShareShare
ReportReport
Posted on by 54

Hello!

I am trying to create a new page that display the sales line items based on the approval status on sales header page. 

I am using Setrange and Settableview but it doesn't display a set of records and just the first one.

Any Idea how to achieve this?

Thank you in advance!

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: How to display records on a new page based on Header and LIne

    hello

    filter your page like this on the header, the subpage of the rows you can filter pr Type= item

    pastedimage1671178536736v1.png

    if instead it is a dry list on the rows that have a certain Status approval in the header, then you have other solutions

    1 . you can build an AL query and read it into the page
    2 . you can filter the rows in AL and mark the recod if the header matches your interests
    3. you can create a flowfield on the rows by recoding the status field in the header, but remember that filters on flowfields can slow down the opening of the page

    DANiele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans