jQuery Grid Plugin - jqGrid - Topic: Select control options automatically re-sorted when values are numeric. http://www.trirand.com/blog/?page_id=393/bugs/select-control-options-automatically-re-sorted-when-values-are-numeric Simple:Press Version 5.7.5.3 Inara on Select control options automatically re-sorted when values are numeric. http://www.trirand.com/blog/?page_id=393/bugs/select-control-options-automatically-re-sorted-when-values-are-numeric#p29195 Bugs http://www.trirand.com/blog/?page_id=393/bugs/select-control-options-automatically-re-sorted-when-values-are-numeric#p29195 A quick update on the issue: jqGrid doesn't re-sort the options if they are passed to editoptions as a string (i.e., in the example above, value:":;8:ACME Inc.;3:Basic, LLC;7:Large Corp;2:Simple Organization;4:Testing Organization").

EDIT: Unfortunately, there is no way to escape colon characters when using the string method, so you can't use any options with a colon in them. Since the object notation is the only way to allow all characters, I would consider the sorting bug to be a major issue.

EDIT 2: The bug with object sorting is apparently inherent to the javascript object implementation: Javascript Object Property Order. Would it be possible to switch over to using a pair of arrays (one for keys, one for values) to support a non-string notation that still allows explicit sorting?

EDIT 3: I just found out that there is undocumented support for custom "delimiter" and "separator" options for the string notation model. Is there a reason they're not included in the wiki documentation, or was that an oversight?

]]> Fri, 19 Jul 2013 23:55:34 +0300 Inara on Select control options automatically re-sorted when values are numeric. http://www.trirand.com/blog/?page_id=393/bugs/select-control-options-automatically-re-sorted-when-values-are-numeric#p29018 Bugs http://www.trirand.com/blog/?page_id=393/bugs/select-control-options-automatically-re-sorted-when-values-are-numeric#p29018 I recently stumbled upon the following issue: For an editable grid (I tested both form edit and inline edit modes), if you pass a select control a value list with only numeric storage values, jqGrid automatically re-sorts the list by the storage values when it converts the values to a dropdown.

For example, if I include the following value list in the editoptions for a select column:

value:{"":"","8":"ACME Inc.","3":"Basic, LLC","7":"Large Corp","2":"Simple Organization","4":"Testing Organization"}

I expect to get the following select list:
<option role="option" value=""></option>
<option role="option" value="8">ACME Inc.</option>
<option role="option" value="3">Basic, LLC</option>
<option role="option" value="7">Large Corp</option>
<option role="option" value="2">Simple Organization</option>
<option role="option" value="4">Testing Organization</option>

Instead, I get this:
<option role="option" value="2">Simple Organization</option>
<option role="option" value="3">Basic, LLC</option>
<option role="option" value="4">Testing Organization</option>
<option role="option" value="7">Large Corp</option>
<option role="option" value="8">ACME Inc.</option>
<option role="option" value=""></option>

Is there any way to turn off this auto-sorting behavior? I would like to be able to display values from the database in alphabetical order while storing their IDs.

]]> Mon, 17 Jun 2013 21:34:05 +0300