How to access the sorted rows in an Angular UI Grid?

Question

I am using the Angular UI Grid to display some data. Sorting is enabled and initialized as well as selecting a single row:

vm.gridOptions = {
    enableSorting: true,
    enableRowSelection: true,
    multiSelect: false,
    noUnselect: true,
    columnDefs: [
        { name: '#', field: 'ID' },
        { name: 'Name', field: 'CODE', sort: { direction: 'asc', priority: 1 } },
        { name: 'Comment', field: 'DESCR' },
    ],
    data: []
};

I am able to select a row and the rows are sorted by the "Name" column in ascending order as configured.

As shown in the UI Grid Tutorial 210, I have added logic to automatically select the first item after my data has been loaded and added to the grid:

datacontext.getAllGcTab(vm.filter).then(function (result) {
    vm.gridOptions.data = result.results;
    vm.gridApi.selection.selectRow(vm.gridOptions.data[0]);
});

But this code is selecting the first item of the unsorted data. There are about 500 items in my grid, which is not much and performs well, but in this case the selected item is somewhere down the line and invisible.

Is there any option to directly access the rows or the sorted data of the UI Grid?

I know that external sorting could solve that problem, because then I would assign the already sorted data to the grid. But this seems to me like an unnecessary overhead...

There is a fix for this on the way - I will post an answer once this has been released. — Spontifixus
– Spontifixus, Commented Oct 14, 2014 at 10:37

Sergei Basharov · Accepted Answer · 2015-04-16 17:21:00Z

12

$scope.gridApi.core.getVisibleRows() returns an array of rows in the current sort/filter order.

answered Apr 16, 2015 at 17:21

Sergei Basharov

54.4k78 gold badges211 silver badges354 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jesper Over a year ago

If it only returns the actual visible rows, it won't do any good. It is unlikely that all 500 rows is visible at the same time.

Sergei Basharov Over a year ago

It returns the whole dataset, I have just checked it: $scope.gridOptions.data.length returns the same value as $scope.gridApi.core.getVisibleRows().length . i.imgur.com/42N6EZA.png

J-Dizzle Over a year ago

note if you have cellTemplates applied (e.g. 12345 -> 12,345) the data returned with this is the data without that formatting applied

HammerNL Over a year ago

@Jesper is right. When using pagination, getVisibleRows() only returns the rows of the current page

Collectives™ on Stack Overflow

How to access the sorted rows in an Angular UI Grid?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related