Data Grid - How can I get the filtered rows?

130

Charles Cymbor posted over 3 years ago

Is there a way to get the rows that are currently shown in the grid (after filters have been applied)?

Use case: I would like to provide a way to 'Select All' rows after applying a filter.

Top Replies

130

Offline Charles Cymbor posted over 3 years ago in reply to Charles Cymbor +1 verified
This works for getting all the filtered row: for ( let i = 0 ; i < grid . actualDataSource . actualCount ; i ++) { const item = grid . actualDataSource...view reply »

130

Verified Answer
Offline Charles Cymbor posted over 3 years ago in reply to Charles Cymbor

This works for getting all the filtered row:

for (let i = 0; i < grid.actualDataSource.actualCount; i++) {

const item = grid.actualDataSource.getItemAtIndex(i);

}
Cancel
Reply

Reject Answer

Cancel
130

Offline Charles Cymbor posted over 3 years ago in reply to Michael DiFilippo

Hi Michael,

I thought this was working but it actually only works for what is visible on the screen. I need to get all the rows that are currently in the table after filtering.
Cancel
Reply

Verify Answer

Cancel
29105

Offline Michael DiFilippo posted over 3 years ago in reply to Michael DiFilippo

I heard back!

While there is no direct collection you can use the following properties off of actualDataSource to perform your own loop and gather the items after filtering.

eg.

public onFilterTextChanged = (e: any) => {

        this.filterText = e.target.value;

        this.setState({filterText: e.target.value});

        this.applyFilter();



        for (let i = this.grid.actualDataSource.firstVisibleIndexRequested; i < this.grid.actualDataSource.lastVisibleIndexRequested; i++) {

            console.log(this.grid.actualDataSource.getItemAtIndex(i));

        }

    }

This was tested with or filtering sample
Cancel
Reply

Verify Answer

Cancel
29105

Offline Michael DiFilippo posted over 3 years ago in reply to Charles Cymbor

Hello Charles,

I am gathering more intel from our development team. Thanks for your patience.
Cancel
Reply

Verify Answer

Cancel
130

Offline Charles Cymbor posted over 3 years ago

I found the rows in the debugger in gridRef.actualDataSource.c2.a4._inner

Is there a public API to get to those rows?
Cancel
Reply

Verify Answer

Cancel