Changes between Version 65 and Version 66 of AjaxList

Timestamp:

2010-09-08T17:01:56Z (15 years ago)

Author:

Serge Okon

Comment:

--

AjaxList

@@ -207 +207 @@
 The joined in columns should be included in the $columns list, if you'd like to display them. The columns you're joining on (in local model) also need to be present in the $columns list, but may be of hidden-type if you prefer not to display them. Remember, all the columns that are referred to by Ajax List must be in the $columns list.
 
-If the foreign key is not "id", you should create an index in MySQL for the foreign key's column. The speed degradation will be awefull if the joinTable has 1000+ entries, and no index is present (~10 or more seconds per list page)
+If the foreign key is not "id", you should create an index in MySQL for the foreign key's column. The speed degradation will be awefull if the joinTable has 1000+ entries, and no index is present (~10 or more seconds per list page).
+
+A real example from the evaluations controller, to join in the Group, the Event, and the Course
+{{{
+#!php
+        $joinTables = array(
+            array( "joinTable" => "groups",
+                   "joinModel" => "Group",
+                   "localKey" => "group_id"),
+            array( "joinTable" => "events",
+                   "joinModel" => "Event",
+                   "localKey" => "event_id"),
+            array("joinTable" => "courses",
+                  "joinModel" => "Course",
+                  "localkey" => "course_id")
+          );
+}}}
 
 ==== Join Table Filters ====