Start Building Professional
Web Apps Today

grid smart render complete

We are using dhtmlx enterprise version 2.1

We have a grid with more than 5000 rows that is loaded using smartrendering. Buffersize is set for 200 rows.

The grid can contain rows from 2 different sources One source is SQL, the other is a stored procedure.

Sorting the grid on the server using SQL works perfectly!!

The stored procedure does not accept sorting parameters so this sort MUST be done on the client by the grid.

Here is the problem.
1) User sees the first 100 rows.
2) User decides to sort on column x
3) we issue the instancesGrid.sortRows(column_index,sortType,sortDirection); command
4) Grid sorting fails.

So we add a step
1) User sees the first 100 rows.
2) User decides to sort on column x
3) We issue instancesGrid.forceFullLoading(200); command.
4) we issue the instancesGrid.sortRows(column_index,sortType,sortDirection); command
5) Grid sorting may or may not fail depending upon whether the loading has finished.

If the loading is finished, then the sort works perfectly.
If the loading is not finished (usually takes 10-15 seconds), the sort fails.

Here is the question.
Is there a way to tell when the forceFullLoading finishes? The onXLE event fires for every chunk, but no way to tell when the last chunk of xml is delivered.

Is it possible to make the forceFullLoading method synchronous so that the next command is not processed until the loading is complete?

Thank you very much for your answer. The customer is very, very angry that the sorting is broken and is questioning why we are using dhtmlx controls.

If you are using dynamic smart rendering mode there is no way to implement client side sorting. You can use dhtmlxConnector to implement server side sorting please find more information here http://dhtmlx.com/docs/products/dhtmlxConnector/index.shtml