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.
On Sun, Jul 26, 2015 at 9:06 PM, Zbigniew Ledwoń <[email protected]> wrote:
> 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 [email protected].
> To post to this group, send email to [email protected].
> 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
