Hello,
After trying all day long to make it work, I couldn’t do it so I am finally asking for help… I am trying to use the Widget CListView in order to display the messages received by a user. I just have to link 2 tables (Message.FromUserId = User.UserId) and i want to display the following fields :
-Message.SentDate
-Message.Subject
-User.Username
In SiteController.php I have:
$dataProvider=new CActiveDataProvider(
'Message',
array(
'criteria'=>array(
'with'=>'user',
'together' => true,
'condition'=>'t.ToUserId=' . Yii::app()->user->userId(),
),
));
$this->render('message',array('dataProvider'=>$dataProvider,));
In Message.php :
<?php $this->widget('zii.widgets.CListView', array(
'dataProvider'=>$dataProvider,
'itemView'=>'_view',
)); ?>
And in the view _view :
<tr>
<td><?php echo CHtml::encode($data->Username); ?></td>
<td><?php echo CHtml::encode($data->Subject); ?></td>
<td><?php echo CHtml::encode($data->DateSent); ?></td>
</tr>
The error message i get is :
"Property "Message.Username" is not defined.
If i remove the line in the _view concerning the $data->Username , it works just fine, so i guess it might somehow be related to the LEFT JOIN… or that I missed something big as I just started with the framework… The error message is quite explicit but i really can’t get how to solve this problem so I would be very grateful if someone could help me with that.
Thank you in advance.