Adding conditions to Laravel has()

Question

I have a table named answers and its columns are id, answers, batch, candidate_id. I want to get all candidates that has no record of answers under batch number of 1.

Is there a way to add condition to this statement (this is in my candidate model) ?

return $this->has('answers', '=', 0)->get();

I tried this way but it didn't work:

return $this->has('answers', '=', 0)->whereBatch(1)->get();

found on documentation "If you need even more power, you may use the whereHas and orWhereHas methods to put "where" conditions on your has queries" — Nabin Kunwar
– Nabin Kunwar, Commented Sep 26, 2014 at 9:42

Jarek Tkaczyk · Accepted Answer · 2014-09-26 09:40:57Z

3

You need whereHas:

$this->whereHas('answers', function ($q) {
   $q->whereBatch(1);
}, '=', 0)->get();

Btw this is exactly the same as calling has with closure as 5th param:

$this->has('answers', '=', 0, 'and', function ($q) {
   $q->whereBatch(1);
})->get();

answered Sep 26, 2014 at 9:40

Jarek Tkaczyk

81.4k27 gold badges167 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding conditions to Laravel has()

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related