Amanuel Nega Amanuel Nega - 2 years ago 127
PHP Question

Laravel Filter child row in hasOne relationship

I have this somewhere in my Laravel app

function result()
return $this->hasOne(InvestigationResult::class, 'assignment_id', 'id');

If the instance is rejected, another report is made and the result of the model should be the last instance of
but laravel takes the first instance.

How do I specify condition on a relationship. If it is possible, I would like to make complex quieries to filter rows eligible for the realtionship.

Answer Source

You can add any of the usual Eloquent database functions to a relationship.

For example, if you want to return a row only if rejected is false:

return $this->hasOne(InvestigationResult::class, 'assignment_id', 'id')
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download