Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

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

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,217 Moderator 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans