Laravel Order By Specific String

Question

I have data on my PostgreSQL like this :

background

id | Size
1  | small
2  | medium
3  | large

art

id | name       | background_id
1  | Shine      | 1
2  | Sun        | 3
3  | Mountain   | 3

I want to get art data orderBy background by it's value from small (small, medium, large) with laravel eloquent

Art::with( [ 'background' => function( $background ) {
    $background->oderBy( DB::raw( "what is this?" ) );
} ] )->get();

How to fix it?

FIELD(type, 'S', 'M', 'L', 'XL')

is not working

Tim Biegeleisen · Accepted Answer · 2016-08-01 10:03:50Z

6

You can use a CASE WHEN expression along with orderByRaw():

$queryOrder = "CASE WHEN Size = 'small' THEN 1 ";
$queryOrder .= "WHEN Size = 'medium' THEN 2 ";
$queryOrder .= "ELSE 3 END";
Art::with('background')
->orderByRaw($queryOrder);
->get();

edited Aug 1, 2016 at 10:03

answered Aug 1, 2016 at 9:38

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jerodev · Accepted Answer · 2016-08-01 09:39:29Z

0

I would add an order field to the background table so ordening can be changed when a new field is added without having to change code. Then, you can use the following query:

Art::with('background')
->orderBy('background.order')
->get();

answered Aug 1, 2016 at 9:39

Jerodev

33.3k11 gold badges96 silver badges113 bronze badges

2 Comments

Yudi Yohanes Septian Gotama Over a year ago

It's show error SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table

Jerodev Over a year ago

Have you set the $table property in your Art model?

Collectives™ on Stack Overflow

Laravel Order By Specific String

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related