Proper use of orderBy() in Eloquent model of Laravel 5

Level 56

What do you mean by not working ?

Level 8

Thanks for your reply. orderBy() is not ordering the sources.id.

pmall

Level 56

Can you show the sql string outputted when replacing get() by toSql() ?

Level 8

Thanks pmall for your reply. I got this "group by reports.report_date order by market_places.id desc" at the end of the Query.

Do you need the whole Query ??

Thanks

Level 88

Yes, post the whole query ;)

Level 8

Here is the whole Query. Thanks

select reports.report_date, group_concat(reports.report_order_id) as order_id from reports left join sources on reports.report_source_id = sources.id where reports.report_date between ? and ? group by reports.report_date order by sources.id asc

Level 88

Oke you group by the parent table and that's why the order of sources doesn't matter anymore, you don't return the soruces you only join them. Since you group it by the parent (reports) the children (sources) will never be added to the select so you won't see them

1 like

Level 8

Thanks bobbybouwmann for your valuable comment. But how can I do that ?? I need to do that. Is it possible do it like ->orderBy('reports.report_source_id','ASC'). ?? Thanks

pmall

Level 56

@afonic try to do it with reports.report_source_id

Level 8

Nothing is working. I am in problem.

Level 88

You can order by source but then you need to group by that table as well

>groupBy('sources.id')
->orderBy('sources.id','ASC')

Level 8

Thanks bobbybouwmann. Your solution gives me different result. I am trying with ->orderBy('reports.report_source_id','ASC') . Why this one is not working ?? I worked with this sort of problems previously. As far as I know these solution should work. But today it is not working. I could not find out the problem. Thanks

fico7489

8 years ago

Level 1

this package can handle this for you in elegant way https://github.com/fico7489/laravel-eloquent-join