Laravel Eloquent: Order By Relationship

Laravel Eloquent: Order By Relationship - Two Ways

Рет қаралды 29,454

Күн бұрын

Quite a regular task, but not a simple solution: how to order query results by a belongsTo relation column? I will show you one "bad" way, and two good ways to do it.
- - - - -
Support the channel by checking out our products:
- Enroll in my Laravel courses: laraveldaily.teachable.com
- Try our Laravel QuickAdminPanel: bit.ly/quickadminpanel
- Purchase my Livewire Kit: livewirekit.com
- View Laravel Code Examples: laravelexamples.com
- Subscribe to my weekly newsletter: bit.ly/laravel-newsletter

Пікірлер: 61

@hansenhalim2265 2 жыл бұрын

Love this performance related videos. Keep up the good work.

@sancasnake 2 жыл бұрын

One of the best channel to find something better for my code consept..

@warchiefsnake 2 жыл бұрын

Great video, solved some of my questions!

@javerleo 2 жыл бұрын

Laravel Daily to the rescue! Thanks again.

@poplach 2 жыл бұрын

Since 'join()' returns query builder, it can used as a scope. Product::select(...)->joinCategories()->orderBy(...)->paginate(...)

@abelenocrodriguez 2 жыл бұрын

Nice examples, thanks!

@greenredrose6577 2 жыл бұрын

I am watching almost all your videos, altough even i know the subjects some of them. Because i am not only learning sth, but also i learn how to think about the codes.

@julienSibille Жыл бұрын

Thank you so much, i was stuck with this one, saved me a lot

@emadfathy1767 Жыл бұрын

Actually you've showed three ways, with/orderBy, collection/sortBy and join/orderBy. Thank you.

@TheJoker-xo4zf Жыл бұрын

Great video. Thank you so much.

@yahyazakaria6584 Жыл бұрын

Thank you this was helpful.

@dhsweb1985 2 жыл бұрын

Great tip! Thanks

@JoaoPauloNovais-me7lj Жыл бұрын

Thanks!!! You're the best!

@MarkSnape 2 жыл бұрын

you could still add 'with' if you want to access the category models

@tbugaevsky Жыл бұрын

Useful, thanks!

@ighmouraceneb 2 жыл бұрын

Thanks for this video . Can we use select and join with hasMany relationships.

@saeedrostami5387 2 жыл бұрын

thank u so much...very usefull...

@CodingBirdsOnline 2 жыл бұрын

Hopefully I will use in comming project ❤️

@surflaweb 2 жыл бұрын

Great bro

@danishdev358 2 жыл бұрын

We also can use callback function inside with function

@msdeav 2 жыл бұрын

Thank you...

@guytresor901 2 жыл бұрын

Thx a lot for this tips and how to search a record in relationship table??

@AddMotionLeb 2 жыл бұрын

great content as usual. I have a question if i may may ask: suppose we have a table of users with region_name where they live and a field of votes ( boolean if voted or not), how to get the total number of user voted per region_name and total number of users in every region but with the same query. Is it possible?

@ClCfe 2 жыл бұрын

Select region_name, count(*) as nb_users, count(if(voted=1, 1, null)) as nb_users_voted From users Group by region_name You can also use sum(), if voted is either 1 or 0 : Sum(voted) as nb_users_voted

@AddMotionLeb 2 жыл бұрын

@@ClCfe thanks a lot

@Xadios7 Жыл бұрын

Thank youuu

@patrickdeserres2609 2 жыл бұрын

thanks for this video 😍, also when i watching your video i was wondering what do you think of aimeos (laravel ecommerce & shop)

@LaravelDaily 2 жыл бұрын

Tried it a few years ago, failed to properly install it, appeared way too heavy for me, haven't tried since then. I just don't work with eshops.

@patrickdeserres2609 2 жыл бұрын

@@LaravelDaily thank's 🙂

@spartacusyusuf9989 2 жыл бұрын

This is a problem as u also have to use groupby and disable strict in database.php for join, in case its a one to many relationship. But i have been using join didn't know the order by accept sub-query also nice video

@anggagantira 2 жыл бұрын

Use select before groupby

@samiullah0011 2 жыл бұрын

Hi which package or tool you are using for measuring time, checking queries and ram memory for laravel as you use in this video.

@daleryanaldover6545 2 жыл бұрын

it's already mentioned at 3:28

@bmtamim7818 2 жыл бұрын

Sir, I am a big fan of you. This is my daily routine to watch atleast one video of you.😍.. I did a project, I want you feedback on that project, How can I send the project to you.. Again, Thanks a lot for your great videos😍. Note: The project take 2 days more to finish. Want to sent it after two days. And can you please review my code 😊

@LaravelDaily 2 жыл бұрын

You can invite me on GitHub, username povilaskorop and email me povilas@laraveldaily.com with all the information about the project. But I can't promise the review, because I stopped doing individual reviews and do them only if the project contains useful topics for others on the channel.

@bmtamim7818 2 жыл бұрын

@@LaravelDaily Thanks a lot, Sure, If you think this project has something to show people then you can review, Thanks for the reply sir😍😍.. Love from Bangladesh 😍😍

@Serzes_ Жыл бұрын

I need your help. What if you want first to group by name and then order by the last record on the database?

@dfordemo981 2 жыл бұрын

very informative, which phpstorm version you are using?

@LaravelDaily 2 жыл бұрын

Haven't updated for a while, 2020.3 from what I remember

@dfordemo981 2 жыл бұрын

@@LaravelDaily ohh, great

@AbdullahAlMamun-xu8ls 2 жыл бұрын

Thank you for this kind of video. Can you explain this "->orderBy(Category::select('name')>whereColumn('categories.id', 'products.category_id'))" orderBy() accept column but how this work?

@thelostrider1 2 жыл бұрын

Look in the video when Povilas showed the (real) query in Debugbar: is a query inside a query. Is "ordering by" the results from that sub-query (select 'name' from 'categories'....)

@necrotikS Жыл бұрын

What about nested relationships? For example: category.user.name

@dimatall 9 ай бұрын

How to use join when Product has several Categories. It will bring duplicates to the table for each Category.

@gunho1324 2 жыл бұрын

Please tutorial for Repository and Service pattern. Thank you!

@LaravelDaily 2 жыл бұрын

Please search for existing videos on the channel next time: kzfaq.info/love/TuplgOBi6tJIlesIboymGAsearch?query=repository

@user-yo3ff4lg2e Жыл бұрын

help me to use this in mongodb

@bumblebity2902 2 жыл бұрын

But you can order by relationship with query inside callback function.

@JY-xv7ic 2 жыл бұрын

the more better way is to create view table..

@MrHimitsu86 Жыл бұрын

Sometimes I was wondering why we need to use eloquent...

@nikza1936 2 жыл бұрын

what if use join : $products=Product::with('category')->join('categories','category_id','=','categories.id')->select('products.*','categories.name')->orderBy('categories.name')->get();

@surflaweb 2 жыл бұрын

Great bro