missing attribute when using join() + one()

[dels07]

Hi there,

I don't know if this is correct behavior of Yii Active Record, consider I have this code

$post = Post::find()
    ->alias('p')
    ->select(['p.*', 'COUNT(c.id) AS comment_count'])
    ->join('LEFT JOIN', 'comments c', 'p.id = c.post_id')
    ->groupBy('c.id')
    ->one();

I cannot access $post->comment_count, but when I use ->asArray()->one, I can access $post['comment_count'], is it possible to return as Post model while having access to comment_count? As this can be used for validation, example

// $post from code above
if ($post->comment_count != 0) {
    throw new UnprocessableEntityHttpException('Cannot delete post with comment(s)');
}

return $post->delete();

[bizley]

I guess you would have to add that comment_count as a property first.

[WinterSilence]

read manual