Changes between Version 6 and Version 7 of DeveloperGuidelines/DataTables

Timestamp:

06/10/11 08:11:25 (14 years ago)

Author:

graeme

Comment:

--

DeveloperGuidelines/DataTables

@@ -11 +11 @@
 || dataTable_iDisplayLength \\'''auto''' || The number of rows to be displayed on a page || Integer || Confusion... dataTable_iDisplayLength and iDisplayLength ||
 || no_sspag \\'''auto''' || This will turn off pagination || Boolean || Pagination is the default and nothing needs to be done to enable it. ||
-|| sortby || This will do an initial sort on the selected column or columns || list of sorting rules. The sorting rules are a list that comprises of the column number followed by the sort direction || default value ![[1,'asc']] ||
+|| sortby || This will do an initial sort on the selected column or columns || list of sorting rules. The sorting rules are a list that comprises of the column number followed by the sort direction || default value ![[1,'asc']] if this is changed then you also need to use the orderby attribute which is used to order teh records coming off from the database.||
 || dataTable_sDom \\'''auto''' || This defines where the controls of the !DataTable will be positioned || String explained in the !DataTables documentation || default value 'fril<"dataTable_table"t>pi' See http://www.datatables.net/usage/options for more information ||
 || dataTable_sPaginationType || This defines what controls are displayed to allow the user to page through the records || String either 'two_button' or 'full_numbers' \\default value 'full_numbers' || ||
@@ -54 +54 @@
     table = db[tablename]
 
+    # Pre-processor
+    def prep(r):
+        if r.interactive:
+            s3mgr.configure(r.tablename,
+                            deletable=True,
+                            addbtn=True)
+        return True
+
+
+    # Post-processor
     def postp(r, output):
         return output
@@ -139 +149 @@
 {{{
 #!div style="font-size: 80%"
-change to teh data model:
+The change to the data model:
   {{{#!python
     table = db.define_table(tablename,
@@ -150 +160 @@
   }}}
 }}}
-[[BR]]
 [[Image(DataTable_with_Status.png)]]
 [[BR]]
@@ -164 +173 @@
   }}}
 }}}
-[[BR]]
 [[Image(DataTable_with_Status_Labels.png)]]
 [[BR]]
 === Sorting by a selected column ===
+To sort a column use the orderby (DAL directive) and sortby (dataTable directive) attributes
+{{{
+#!div style="font-size: 80%"
+Add this to the prep() function of the controller:
+  {{{#!python
+            s3mgr.configure(r.tablename,
+                            deletable=True,
+                            addbtn=True,
+                            orderby = tablename+".status",
+                            sortby = [[3, 'asc']])            
+  }}}
+}}}
+[[Image(DataTable_Sorted by_Status.png)]]
+[[BR]]
 
 === Filter Rows ===