ManyMany / protected / views / song / grid.php

[yjeroen]

This part of your code is the question, right?

if ($this->action->id === 'reviews') {

// This is the bit that doesn't work.
// To produce a table of song reviews... How??
$columns[] = array(
    'name' => 'song.reviews.review',
    'filter' => CHtml::activeTextField($song, 'review'),
);
$song->criteria->group = 'reviews.song_id';
$song->criteria->with = array('song', 'song.reviews', 'genre');
$song->criteria->together = true;

}

I assume by grouping it to song_id, only one row is returned by the database per song. So you see only one review per song. Correct?

[yjeroen]

What I do for many_many or has_many gridviews, I use:

$criteria->join = 'LEFT OUTER JOIN ( subquery with group_concat ) as relationName ON (relationName.song_id=t.id)';

[yjeroen]

its for if you want gridviews to work while using eager loading instead of lazy loading like we're doing now

Example copy/paste from my code:

        $criteria->join =  'LEFT OUTER JOIN 
        (SELECT plaatsen.incident_id, GROUP_CONCAT(plaatsen.plaats ORDER BY plaatsen.plaats SEPARATOR \'<br>\') as plaats
         FROM `ics_incident_plaats` `plaatsen`
         LEFT OUTER JOIN `ics_incident` `t` 
         ON (`plaatsen`.`incident_id`=`t`.`id`)
         GROUP BY plaatsen.incident_id) AS plaatsen 
    ON (`plaatsen`.`incident_id`=`t`.`id`)
    LEFT OUTER JOIN 
        (SELECT overigeLocaties.incident_id, GROUP_CONCAT(overigeLocaties.locatie ORDER BY overigeLocaties.locatie SEPARATOR \'<br>\') as locatie
         FROM `ics_incident_overige_locatie` `overigeLocaties`
         LEFT OUTER JOIN `ics_incident` `t` 
         ON (`overigeLocaties`.`incident_id`=`t`.`id`)
         GROUP BY overigeLocaties.incident_id) AS overigeLocaties 
    ON (`overigeLocaties`.`incident_id`=`t`.`id`)
    ';