convert simple mysql query into eloquent query with relation ship

SELECT * FROM `order_status_details` WHERE id IN(select max(id) from order_status_details group by `order_detail_id`) and order_id=210


i Want to add above query into this

OrderStatusDetail::with(['orderStatus'=>function($query){
             $query->select('id','name');   
            },'orders','orderDetails','orders.pickup'])->where('order_id',210)->whereIn("select max(id) from order_status_details group by `order_detail_id`")->get()->toArray();

mballaag

7 years ago

Level 2

try this for the first query:

OrderStatusDetail::whereIn('id', function($query){
             $query->max('id')
               -> groupBy('order_detail_id');   
            })->where('order_id',210)->get()->toArray();

yusuf128

7 years ago

Level 1

@mballaag ,thanks for response but this error occured

Column not found: 1054 Unknown column 'id' in 'field list' (SQL: select max(`id`) as aggregate)

Please or to participate in this conversation.