Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

Posted on by 65

Hi all,

I need suggestions regarding this scenario that how can I solve it.

Let's say my table "Student" has four entries: 

NAME Age
A 2
B 3
C 7
D 6



Now when I apply filter to age column such that only students that have ages less than 4 are shown. ( in this example the rows will then be 2 )

So, what I want is to get the table buffer of Student in the display method that has only these two rows or generally speaking table rows after the filters have been applied.

Any help will be great.

Thanks.

  • ergun sahin Profile Picture
    ergun sahin 8,812 Super User 2024 Season 1 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    Write a simple select clause.

    while select student
        where student.Age < 4
        {
        }

    I don't understand exactly what you are trying to do.
    Let's break it up a little. The problem seems to have nothing to do with the display method. (Display method to show the processed data to the user.)
    I think your problem is about getting the data you want.
    If you can tell us what you are doing and at what point you have difficulties, we can help you more easily.

  • OsamaAG Profile Picture
    OsamaAG 65 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    No No I don't want to show the whole table in the single field. I just want the table buffer in the display method after the filters are applied.

  • ergun sahin Profile Picture
    ergun sahin 8,812 Super User 2024 Season 1 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    I don't get it, it's not possible to show a table in a single field.

    If the purpose is to show names with separators, it is of course possible (like A-B).

    Or you can write something like "A/2-B/3" in the new field, as long as the length isn't an issue.

  • OsamaAG Profile Picture
    OsamaAG 65 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    Thanks ergun sahin for reply.

    No I am not trying to create a lookup. I am trying to add a field in my grid through display method.

    In my scenario, I want the grid's rows in the display method after the filter is applied.

    I hope it clears a bit.

  • ergun sahin Profile Picture
    ergun sahin 8,812 Super User 2024 Season 1 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    If I'm not wrong, you want to create a lookup with a range

    If it is a custom form, it is no different from 2012, you can use the example below.

    docs.microsoft.com/.../how-to-add-a-lookup-form-to-a-control

    If you are going to write to system forms or a form in a different model, the code is still the same but the location is different (you need to use extension)

    msdynamics.nevoitech.com/.../

  • OsamaAG Profile Picture
    OsamaAG 65 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    In D365 I am trying to add a column to a grid in the form and for that using display method.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    Hi,

    Is this for a modification of a form/table/grid that you make in AX2012/D365 or for a PowerApp that you embed in D365?

    Would be great if you could provide some additional information.

    Many thanks,

    Ludwig

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans