how to use order by with condition in laravel?

Scenario: supposed i have data, where status is completed, now i want status completed displayed at the bottom, otherwise the most recent created displayed at the top, how can you query it using orderBY or any method in laravel? pls help im new in laravel thank you..

This is the query i tried: // The list of completed surveys is displayed at the bottom. Otherwise, the most recent date of creation is displayed at the top.

        $surveys = $query->select('surveys.*')
            ->orderBy("status", 'asc')
            ->get();

jlrdw

2 years ago

Level 75

Use a WHERE clause prior to the ORDER BY.

https://laravel.com/docs/10.x/queries#where-clauses

1 like

asathler

2 years ago

Level 19

Hi @isong1234

You may change your code a little bit, like so:

$surveys = $query->table('surveys')
    ->where('active', true)
    // ->select('*') // it's default behavior
    ->orderBy('status', 'asc')
    ->get();

It combines where and orberBy through Eloquent.

...and check the laravel documentation quoted above by @jlrdw.

Hope to helped

2 likes

Please or to participate in this conversation.