Skip to main content

Notifications

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

How to add filter with the grid?

Posted on by 2,203 Super User 2024 Season 1

So I have created a page and inside that page, I'm using the grid..

pastedimage1675775431525v1.png

above that grid I have created some of the columns.. as you can see in the image.. when I put the value in any of the columns.. what I have observed.. it is different for every record below the grid.

for example, if I select "Vendor Two" in the find column when selecting the first record of the grid.

pastedimage1675775601748v3.png

as soon as I select another record in the grid.. all of the above columns get reset...

pastedimage1675775672371v4.png
When I go back to the first row I can see my values..

Note that all of the fields above that grid are global variables.. on my page.. the fields above grid are not the part of my table..

What I want is for the values of the above group to remain the same for all of the records in grid..

Kindly tell me you know how to achieve this... thanks.

Code:
pastedimage1675776162083v5.png

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: How to add filter with the grid?

    Hello  - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist.  If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    I will open this up to the community in case they have something to add.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans