Group By operation is not working, if listGrid is having more than 2 page of records

[vnathank]

Hi Isomorphic,
We are using Smart Gwt-5.1 (19^th January build)
Browser: Google Chrome, version: 47.0.2526.106 m

Issue: “Group By” operation is not working if listGrid is having more than 2 page of records .

Description: After adding pagination in listGrid, we are not able to perform "Group By".
As per our understating with SmartGWT behaviour, group by will work only if all the records are loaded to UI.

Scenario: Suppose we have 90 records and we have to perform group by operation in listGrid.
Due to pagination, for 1^st request list grid will fetch -- 30 records
After selecting "Group By" 2^nd request is initiated from list grid for next 30 records -- 60 records loaded
But "Group By" is not applied in the grid because all records are not loaded/fetched. (Total records are 90).

In this case, User is not clear on whether "Group By" is not working or after loading all records "Group By" will be applied.

Note:
In case of check box, if all records are not loaded in UI, on clicking the check box, UI shows an tool tip message as follows.
"Can't select that many records at once".

Please find the below URL, which we have posted query earlier for checkbox issue.
http://forums.smartclient.com/forum/...election-issue


Please let us know whether similar kind of solution is possible for "Group By" option also Or any other alternates to resolve this issue.

Thanks,

[Isomorphic]

See groupByMaxRecords - if the total number of records available from the server is less than this threshold, the ListGrid will fetch remaining records and perform grouping.

The reason you are not seeing all records fetched is almost certainly the same issue we already told you about - your transformRequest implementation is broken.

There is no point in reporting any further grid-related bugs to us until you have fixed your code.

[vnathank]

Hi Isomorphic,

Once again thanks for your support.
We are able to resolve this issue by using “groupByMaxRecords”.
Please find the below description and let us know whether we are using it on correct format or not.

Description: we are using below properties:-

setDataFetchMode (FetchMode.PAGED);
setDataPageSize (30);
setDrawAheadRatio (1.0f);
setGroupByMaxRecords (getEndRow());

At the time of calling addDataArrivedHandler for listGrid we are try to setting value for groupByMaxRecord and providing end Row as a parameter.
Please let us know this approach is fine or we need to fix this issue in some other way.

[Isomorphic]

There's not much we can say about this code as it's just a couple of ordinary settings. But, again, you still need to fix your code from the other thread, where in transformRequest you modify the startRow/endRow settings. This is invalid, and it will break a number of different features.