Level 41
Instead of joining with other tables, what about using querying relationship existence?
That looks cleaner and avoid adding extra columns to your query.
Nov 5, 2021
4
Level 12
exists() query condition in left join
Hello. I'm having a query that is based on GET parameters. In short, if some parameters (checkboxes) are set the query is changing. But now I need a little bit different structure for one of the checkboxes. When checked - I need to check if there is an existing row with a specific matching column (detail_id) value from another table. I tried with:
$upgrading->leftJoin('anotherTable', function($join) {
$join->on('table.id', '=', 'anotheTable.detail_id')->exists();
});
The structure of the query is:
$upgrading = Table::query();
if(!empty($request->someGetParam)) {
..............
}
if(!empty($request->someGetParam)) {
..............
}
if(!empty($request->someGetParam)) {
$upgrading->leftJoin('anotherTable', function($join) {
$join->on('table.id', '=', 'anotheTable.detail_id')->exists();
});
}
$upgradingFinal = $upgrading->where(....)->paginate(20);
Any idea?
Level 122
the ->exists() terminates and executes the query
You should perform the join AND add a where query for the related record.
Level 12
if(!empty($request->someGetParam)) {
$upgrading->join('anotherTable', 'anotherTable.detail_id', '=', 'table.id');
$upgrading->where('anotherTable.detail_id', '=', 'table.id');
});
?
Level 122
btw, this is a bit more elegant
if($request->has('someGetParam')) {
1 like
Please or to participate in this conversation.