Grid groupBy on load with datastore

Suite and Optimus Suite 5
#1

I have a grid with a lot of data and I want it to load up already grouped by the first column, so I used grid3.groupBy(0); and this worked fine when I was loading the data through static XML. However, once I synced the grid with datastore the groupBy stopped working without a page refresh. How can I get it working when the page first loads again?

#2

Hmm…found one more problem. I’m using dhtmlxgrid_keymap_excel.js and it has stopped working now that I’ve attached the grid to datastore. Is this a known issue? Is there any fix for it?

#3

Unfortunately the pointed issues cannot be reproduced locally.
If issue still occurs - please, provide us with any kind of sample of your code or a complete demo/demo link where the issue can be reproduced.

#4

Thanks for getting back to me. I’ve attached a demo with everything except the dhtmlx codebase files. I’m using the Pro version 3.6 for the Suite files and Pro v.3.7 for the Scheduler.

Thanks for your help :smiley:
demo.zip (29.6 KB)

#5

Unfortunately there is no callback function in sync() method.
Please, try to use onXLE event of dhtmlxGrid:

grid1.attachEvent("onXLE", function(){ grid1.groupBy(1); });

#6

That was exactly what I needed. Thanks!