Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
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 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 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 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans