mardi 21 juin 2016

Subquery with eloquent model in laravel 5

I have the following raw query:

select * 
from (select * from settings order by priority desc) x
group by name

I would like to use a laravel 5 query builder instead but cant get the subquery to work. Is there a way to do this without using raw query's?

The table:

id - name - priority
1    1      1
2    1      2
3    2      1

In the above case It will return row 2 and 3 like I want to

I tried this query:

$settings = \App\Setting::where('user_id', Auth::id())->orWhere('tool_id', $id)->groupBy('name')->orderBy('priority', 'desc')->get();

But this will return row 1 and 3.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire