[BennyParticipant]

beginupdate does not work for me. When calling setoptions or groups, I get the error: Cannot read properties of null (reading ‘visiblerecords’).

$(‘#jqxgrid’).jqxGrid(‘beginupdate’);
$(‘#jqxgrid’).jqxGrid(‘groups’, [‘firstname’])
$(‘#jqxgrid’).jqxGrid(‘endupdate’);

[BennyParticipant]

I expected updatebounddata() to keep the configured sorting and grouping and completely re-bind and re-render everything, since in the documentation is says: “To make a full update, do not pass any parameter.”

However after doing some performance testing, the grid API seems to be more designed to respond to user inputs, applying one change at a time. When making many changes in one go, it is very inefficient and I need to deal with all these strange cases. It is much faster to create a new grid, which also simplifies my code a lot. Creating a new grid is very fast.

[BennyParticipant]

Correction last post is about grouping: // No extra parameter: grouping is removed.

After some more testing, It seems that the same does apply for sorting:
$(‘#jqxgrid’).jqxGrid(‘sortby’, ‘firstname’, ‘desc’);
$(‘#jqxgrid’).jqxGrid(‘updatebounddata’); // sorting is removed

$(‘#jqxgrid’).jqxGrid(‘sortby’, ‘firstname’, ‘desc’);
$(‘#jqxgrid’).jqxGrid(‘updatebounddata’, ‘sort’); //sorting remains, but only when passing ‘sort’ or ‘cells’

[BennyParticipant]

Hi Peter,

I forgot to mention that we use Angular, but this works great:

onGroupschanged($event) {
let noGrouping = $event.args.groups.length === 0;
this.myGrid.setOptions({ virtualmode: noGrouping , pageable: noGrouping });
}

Thanks,
Benny.

[BennyParticipant]

Hi
Is there any solution to stop the behavior of horizontal movement(swipe top/button) on the touchpad when there is no vertical scroll and vice versa.

Thanks

[BennyParticipant]

Hello Peter,

The horizontal scrollbar not working using the touchpad when horizontal and vertical both scrollbar coming.

Sample JQXgrid

Thanks

[BennyParticipant]

I have a grid with dynamic column rendering which allows column reordering, grouping etc as well. As soon as I start reordering there are many events which get triggered from various jqx components like jqxcombobox.js,jqxscrollbar.js which are registered at the document level causing the angular zone to detect some changes causing heavy scripting in the browser which degrades the performance(in IE)
The slowness is up to such a level that if I start dragging one column I end up dragging a column beside it.

With the performance Stats shared above, you can see the yellow spikes which are continuous in nature

[BennyParticipant]

Hi
Please see the below links, can I allow the same behaviour in jqx tree where moving of a node gives us idea where the node can/cannot be dropped.

Tree node move snapshot

node move snapshot

[BennyParticipant]

Is there any wayaround for angular2/4

[BennyParticipant]

Excellent! Thank you!

Regards, Benny

[BennyParticipant]

So what you are saying is that you apply paging before grouping. First the data is divided into the page size of 10.
And after that you apply the grouping, individually per page.

To us it would be more helpful if we can do it the other way around. First apply grouping on all data > then apply paging so that only 10 items are shown.

[BennyParticipant]

Hi Peter,

Yes I get that paging is limited to 10 items when I have set that page size, but I am suggesting that Andrew -> Black Tea has in total 3 records. Why can I not see 3 records on page 1? The group “Peppermint Mocha Twist” should then move to next page so that it is still 10 items for first page. See screenshots:

Page 1: https://www.dropbox.com/s/6550b1gwjlwg0km/page%201.png?dl=0
Page 2: https://www.dropbox.com/s/gz8mw9v0h6snef8/page%202.png?dl=0

Also, if I don’t do step 3 in my first post (i.e. I don’t sort on anything), it works as expected. Then I only get one subgroup per parent group no matter if I go to the next pages. So in the example with Andrew -> Black Tea, I clearly see that it has 3 items.

[BennyParticipant]

1. Yes we know that you can sort within groups, we are asking for sorting of grouping headings.

2. We also know that multiple sorting is not supported. As in the link you pointed out, this is also a formal request to implement multiple sorting. We see it as an important feature to have in a grid component.

I will also send the request to sales@jqwidgets.com.

Thank you

[BennyParticipant]

We decided to go with the solution below, which reduced initialization time by 30% for us. Temporarily replacing the isHidden function is not great, but small and effective enough to be acceptable for us. Hopefully this performance hack will help other developers building a page where the grid is the primary component of the page.

REMOVED CODE ( EULA VIOLATION )!

[BennyParticipant]

We think that the jqx grid is a great product. Once it is initialized it performs very well, even with a few thousand rows of data (with paging). For a single page application the initialization time would not be as much of a problem, unfortunately we are not there yet. Since the initialization time is worse than our old component, this has become a critical problem for us.

It looks like the performance hack in the examples doesn’t really work. The rendering isn’t done while hidden, it’s just postponed in the code. As you said in http://www.jqwidgets.com/community/topic/making-grid-inside-hidden-container/ “You can’t and shouldn’t create a Grid from hidden container”. This makes sense, however we try to do it intentionally. We would like the grid to be rendered while detached or in a document fragment while the jqx.isHidden() function still returns false. But it does not look like there is an override for that, unless you have any suggestions?

[Author]

Posts