Changes between Version 1 and Version 2 of AlphaSort

Timestamp:

01/17/10 19:00:29 (15 years ago)

Author:

Fran Boon

Comment:

--

AlphaSort

@@ -10 +10 @@
 This one is a Database one using the IS_ONE_OF() custom validator from {{{modules/validators.pty}}}
 
-js list sorter:
+Massimo has put back-end sorting into [http://bazaar.launchpad.net/~mdipierro/web2py/devel/revision/1543 Trunk]:
+ * IS_IN_SET(...,sort=True) and/or IS_IN_DB(...,sort=True)
+  * needs porting to IS_ONE_OF()
+  * needs testing
+
+Foront-end soring can be done with JS:
  * http://stackoverflow.com/questions/278089/javascript-to-sort-contents-of-select-element/278509#278509
+ * This works with capitalised/non merged but means that the NULL in IS_NULL_OR() isn't the default:
+{{{
+<script>
+jQuery(document).ready(function(){
+  jQuery("select").each(function(){
+     jQuery(this).html(jQuery(this).children("option").sort(function(a,b) {
+       return (a.text.toUpperCase() == b.text.toUpperCase())?0:((a.text.toUpperCase() < b.text.toUpperCase())?-1:1);
+      }));
+      // jQuery(this).children("option:first").attr("selected","selected");
+  });
+});
+</script>
+}}}
 
-As far as sorting right in the backend is concerned - models/05_or.py line 107, tried putting .select(orderby = db.or_organsation.name)[0]...
-But that did not work out... 
-
-Q: If its possible to put a javascript fix where does one put a page specific js ?[[BR]]
+Q: Where does one put page-specific Javascript ?[[BR]]
 A: {{{views/module/resource_method.html}}}
 
-For Dictionary-based ones:
+For Dictionary-based ones can:
 {{{
 In  models/05_or.py change: