web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to add filter with the grid?

(0) ShareShare
ReportReport
Posted on by 2,304 Moderator

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

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,421

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,878 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,645 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans