Level 39
?
What do you expect as result?
A scope is filter , ...
Mar 30, 2022
4
Level 4
how to do a raw query within a scope function of a model?
I have a raw query that I would like to use as a scope function so that I may simply call the function to get all the data I need instead of writing out all the inner joins using the model.
something like this:
public function scopeGetMyData(){
return $query->raw(" SELECT * FROM table LEFT JOIN table2 on table2.id = table.id");
}
I know I could do something like return DB::select(DB::raw($sqlQuery));, but if I'm doing that is there any point in putting this in the model? Why not just put it somewhere else like a controller or another class.
Level 4
@sr57 I don't have much choice in making it a scope. Those are the requirements.
Level 73
This is ugly anyway, but you can do it using eloquent, it does not have to be raw even though you can use the selectRaw method.
public function scopeGetMyData( Builder $query )
{
return $query->leftJoin('table2', 'table2.id', '=', 'table.table2_id');
}
so then:
Table::select(.... columns here ...)->where('table.id', 1)->getMyData()->first();
use selectRaw if you want to add aliases as well.
Level 4
@Nakov thank you! I completely forgot about using $query->leftjoin()
Please or to participate in this conversation.