Guriddo » Topic: Set selection when data loaded

Set selection when data loaded

Guriddo
Set selection when data loaded

This topic has 5 replies, 3 voices, and was last updated 16 years, 4 months ago by tony.

Creator

Topic
November 27, 2009 at 10:16 am #74821

bernie.blakeney
Participant

Is there anyway to return the selection state with my data set so that rows will be selected based on data in my db? I save the selected state of each row into a database so the user can re-use a selection but I can't figure out an effiecient way to set the selection from the query.

Thanks
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies
November 27, 2009 at 11:32 am #91093

Rumen
Participant

One way to do it is to pass the selected rows as a javascript array, and then hook the gridComplete event, where you can set selected rows based on the values in the array, e.g. something along the lines of

jQuery('#JQGridID').setGridParam( {gridComplete: function()

November 27, 2009 at 11:49 am #91094

bernie.blakeney
Participant

Thanks Rumen,

I've tried something like that but it is dreadfully slow.

November 30, 2009 at 12:49 pm #91126

tony
Keymaster

Hello,

It depends how many data you loop.

Tony

December 2, 2009 at 4:23 pm #91183

bernie.blakeney
Participant

Thanks Tony.

I don't have that much data – about 500 rows. Firefox gives me that “a script is running slowly” message after only about 120 records.

It would be really great if in the data I'm returning I could add an attribute to the row element that jqgrid would use to select the row – something like “”. Then jqgrid could set the value when painting the grid which I assume would be much faster.

Bernie

December 2, 2009 at 4:58 pm #91187

tony
Keymaster

Hello,

You can try to use afterInsertRow – where you can set the selection.

Note that in this case gridview mode should be false.

Please let me know if this is faster.

Regards

Tony
Author

Replies

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Copyright 2014 TriRand LtdAll Rights ReservedRSS