DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@Poetawd
If you want to search related items, you need to use or_like_related():

Code:

//Check if Search data is sent
if($this->input->post('sSearch'))
{                
    //Initiate a new SQL Query group
    $obj->group_start();
                
    //Create a loop to go over each column
    foreach($columns as $position => $column)
    {
        //Add a the SQL statment for searching in that column to the Query Group
        $obj->or_like($column, $this->input->post('sSearch'));
    }

    // You need some way to know which related object to look at
    // Here, I've chosen to have an array of related objects and their columns.
    foreach($related as $related_object => $columns)
    {
        foreach($columns as $column) {
            //Add a the SQL statment for searching in that column to the Query Group
            $obj->or_like_related($related_object, $column, $this->input->post('sSearch'));
        }
    }
          
    //Close the SQL Query Group
    $obj->group_end();
}

Hopefully that helps.