I am using laravel 5.7
When I use whereHas
to check a relation’s existence, I face with Unknown column "has" in 'where clause
Error! Why?
this is my code:
$query->whereHas('departures', function ( $query) { $query->whereBetween('depart_date', [date($this->data['departFrom_date']), date($this->data['departTo_date'])]); });
and this is my model part:
public function departures() { return $this->hasMany(CruiseSailingDepartures::class); }
Update:
The query was started with:
$query = DB::table('table_name');
Advertisement
Answer
I have found my problem, I was using DB::table('tablename')
instead of using the Model (TableName:: ...
)
Thanks for all answers