Level 63
You just have to add ->withTrashed() to your query.
$employees = Employee::withTrashed()->get();
Nov 27, 2023
8
Level 1
Exclude or Hide from returned data
I am new to Laravel and I don't know should I do using eloquent. I have three tables employees, position and division. I'd like to hide employee or employees either division or position that assigned to them was soft deleted. Any suggestions? Can someone convert my query to eloquent.
Employee Model: public function position() { return $this->belongsTo(Position::class); }
public function division()
{
return $this->belongsTo(Division::class);
}
Here's my query: $employees = Employee::with('division', 'position', 'role')->where('status', '!=', 'Deleted')->orderBy('last_name', 'asc')->get();
SELECT first_name, last_name, title, p.deleted_at AS deleted_position FROM employees e LEFT JOIN employee_positions p ON e.position_id = p.id WHERE p.deleted_at IS NULL;
Level 1
@vincent15000 hi, what i wanted is to hide or exclude the employee when the position is soft deleted. How to achieve it with this line.
$employees = Employee::with('division', 'position', 'role')->where('status', '!=', 'Deleted')->orderBy('last_name', 'asc')->get();
1 like
Level 63
@ressil Ok.
$employees = Employee::with('division', 'position', 'role')->whereHas('position')->where('status', '!=', 'Deleted')->orderBy('last_name', 'asc')->get();
https://laravel.com/docs/10.x/eloquent-relationships#querying-relationship-existence
Level 104
@vincent15000 just has is enough
$employees = Employee::query()
->has('position')
->with('division', 'position', 'role')
->where('status', '!=', 'Deleted')
->orderBy('last_name', 'asc')
->get();
2 likes
Level 63
@tykus What's the real difference between both ?
Level 104
@vincent15000 nothing... whereHas just "suggests" some constraint IMHO
1 like
Level 63
@tykus Hmmm yes that's right, it allows to add additional constraints.
Level 1
@tykus thank you @vincent15000 thank you
1 like
Please or to participate in this conversation.