Changes between Version 54 and Version 55 of AjaxList


Ignore:
Timestamp:
2010-09-08T16:01:09Z (14 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AjaxList

    v54 v55  
    172172Joining in table in Ajax List lets you bring in other relevant data into your list. You can look up course name by their id's or check with classes the student is enrolled in.
    173173
    174 All join are LEFT JOINs. One to one joins are supported the best, like looking up a name using an id. One to many joins a little more complex, since number on items in the list won't increase to accommodate the "many" entries". However, an extra filter or a join filter (bellow) can be used to isolate items of interest from the join. Otherwise, a {{{GROUP by Model.id }}} statement is issued  to automatically group those "many" items back into one.
     174All joins are LEFT JOINs. One-to-one joins are supported the best, and can be used to look up a name using an id, and so forth. One-to-many joins a little more complex, since number on items in the list won't increase to accommodate the "many" entries". However, an extra filter or a join filter (bellow) can be used to isolate items of interest from the join. Otherwise, a {{{GROUP by Model.id }}} statement is issued  to automatically group those "many" items back into one item per original list entry.
    175175
    176176If simply joining in tables, without join filter, the $joinTable array contains an array for each table joined in:
    177177{{{
     178!php
    178179$joinTables = array(
    179    array( "
     180   array( "joinTable" => "table_name", // The name of the table to be joined in
     181          "joinModel" => "Group",
     182          "localKey" => "group_id"
    180183}}}
    181184