Laravel Eloquent 'WITH' statement query

Question

How to convert this mysql query to Eloquent

with wmh as (select * from whatsapp_message_histories ORDER BY created_at LIMIT 1) 

select DISTINCT whatsapp_histories.*, wmh.created_at from whatsapp_histories

left join wmh on wmh.whatsapp_history_id = whatsapp_histories.id

ORDER BY wmh.created_at

Please Help me, thanks a lot!

(Edited) My Problem is, I have Eloquent Model whatsapp_histories, has a relation to whatsapp_message_histories (using hasMany). My Objective is need to display whatsapp_histories order by whatsapp_message_histories.created_at. (This is eloquent, because i need to display other whatsapp_histories's relation). I can solve it in native way, but not in eloquent, but i'm not allowed to change the previous eloquent code

have you defined any relationship for your two tables?

Nikhil Radadiya
– Nikhil Radadiya

2021-04-01 05:12:01 +00:00
Commented Apr 1, 2021 at 5:12 — Nikhil Radadiya
– Nikhil Radadiya, Commented Apr 1, 2021 at 5:12
yes i have defined it

Yonathan Pamungkas Putra
– Yonathan Pamungkas Putra

2021-04-01 06:30:57 +00:00
Commented Apr 1, 2021 at 6:30 — Yonathan Pamungkas Putra
– Yonathan Pamungkas Putra, Commented Apr 1, 2021 at 6:30

Varinder Kaur · Accepted Answer · 2021-04-01 07:01:56Z

1

Try this:-

whm::with('whatsapp_histories',function($join){
   $join->on('wmh.whatsapp_history_id','=','whatsapp_histories.id');
   $join->orderBy('whatsapp_histories.created_at','ASC');
   $join->limit(1);
})->orderBy('wmh.created_at','ASC)->get();

answered Apr 1, 2021 at 7:01

Varinder Kaur

843 bronze badges

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

1 Comment

Varinder Kaur Over a year ago

You can use this:-

whatsapp_histories::with('whm',function($join){     $join->on('whatsapp_histories.id','=','wmh.whatsapp_history_id');     $join->orderBy('wmh.created_at','ASC); }) ->select('whatsapp_histories.*','wmh.created_at') ->orderBy('whatsapp_histories.created_at','ASC') ->get();

Collectives™ on Stack Overflow

Laravel Eloquent 'WITH' statement query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related