CakePHP 3 - hasMany through association

[Zbigniew Ledwoń]

if I have an association exactly like in the CookBook here:
http://book.cakephp.org/3.0/en/orm/associations.html#belongstomany-associations

class StudentsTable extends Table{
public function initialize(array $config)
{
$this->belongsToMany('Courses', [
'through' => 'CourseMemberships',
]);
}}
class CoursesTable extends Table{
public function initialize(array $config)
{
$this->belongsToMany('Students', [
'through' => 'CourseMemberships',
]);
}}
class CoursesMembershipsTable extends Table{
public function initialize(array $config)
{
$this->belongsTo('Students');
$this->belongsTo('Courses');
}}

Student BelongsToMany CourseCourse BelongsToMany Student

id | student_id | course_id | days_attended | grade

*How do I find all Courses that given Student has Grade == "A"?*
*Would following code work fine?*

$query = $this->Courses->find('all')

->contain(['Students', 'CourseMemberships'])

->where(['Students.id' => $student_id, 'CourseMemberships.grade' => 'A'
]);
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+***@googlegroups.com.
To post to this group, send email to cake-***@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

[Rafael Queiroz]

Check:
http://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#filtering-by-associated-data

Try:

$query = $this->Courses->find('all')
->contain(['Students', 'CourseMemberships'])
->where(['Students.id' => $student_id])
->matching('CourseMemberships', function ($q) {
return $q->where([ 'CourseMemberships.grade' =>
'A']);
});

* Recommendation: use $studentId, not $student_id.

Post by Zbigniew Ledwoń
http://book.cakephp.org/3.0/en/orm/associations.html#belongstomany-associations
class StudentsTable extends Table{
public function initialize(array $config)
{
$this->belongsToMany('Courses', [
'through' => 'CourseMemberships',
]);
}}
class CoursesTable extends Table{
public function initialize(array $config)
{
$this->belongsToMany('Students', [
'through' => 'CourseMemberships',
]);
}}
class CoursesMembershipsTable extends Table{
public function initialize(array $config)
{
$this->belongsTo('Students');
$this->belongsTo('Courses');
}}
Student BelongsToMany CourseCourse BelongsToMany Student
id | student_id | course_id | days_attended | grade
*How do I find all Courses that given Student has Grade == "A"?*
*Would following code work fine?*
$query = $this->Courses->find('all')
->contain(['Students', 'CourseMemberships'])
->where(['Students.id' => $student_id, 'CourseMemberships.grade' =>
'A']);
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

--
Atenciosamente,

Rafael F. Queiroz
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+***@googlegroups.com.
To post to this group, send email to cake-***@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.