Django-Filter - Filtering Django Querysets, Class-Based Views and REST Framework Integration

[@xzex2609]

I can not believe that this video is only 30 minutes , compacts with lots of information . very useful stuffs.

[@bugbytes3923]

Thanks a lot! Great to hear that, cheers!

[@xzex2609]

This channel is Django gold mine .

[@bugbytes3923]

@@xzex2609 thanks a lot for that, glad you think so, cheers!!

[@garzuze]

Straight to the point and very informational. Loved it!

[@bugbytes3923]

Thanks a lot!

[@JA-ur8ob]

Thanks heaps for this video mate. Really appreciate you going through class-based views as well.

[@bugbytes3923]

No worries mate - thanks for watching!

[@Davidkiania]

I really really love this channel ... I have learned in 15 mins what could have taken me an hour in other videos and your explanations are excellent and concise. Thank you.

[@bugbytes3923]

Thank you very much, I'm glad you're enjoying the videos!

[@seydinaoumarsamabaly1806]

Always surprising with content of quality. Thank you for all mate.

[@bugbytes3923]

Thank you!

[@sa_codes]

I needed this video so much! Thanks so much for making all of your videos!

[@bugbytes3923]

Thanks Ben - glad it was useful!

[@sa_codes]

@@bugbytes3923 No problem. If you ever need a video or blog idea, I've been trying to find a good way to use HTMX to display messages from the Django Message system as they are created, but haven't found a clean way to do it yet. Seems like the sort of thing I normally learn from your videos haha!

[@axelb.2006]

For me, the best Channel with a big C. Thanks

[@bugbytes3923]

Thanks so much!

[@akunau505]

Wow!! This was so informative, thank you!!

[@bugbytes3923]

Thanks a lot!

[@prajjwaldangal2022]

really clear explanation

[@bugbytes3923]

Thanks a lot!

[@metalhoe]

Thank you, this tutorial helped me very much. I was basing my stuff on another django tutorial of filter search but it was outdated, started new with this one and everything works. All the best 😃

[@bugbytes3923]

Glad to hear that, thanks a lot!

[@AliBakhshi-s3r]

After 3 days of trying, by this video my problem is solved :D

[@bugbytes3923]

Awesome, glad to hear the video helped! 😄

[@calimhiro]

very great explanations, simple and clear! I love your videos!

[@bugbytes3923]

Thanks a lot!

As always, your videos are super useful

[@bugbytes3923]

Thanks a lot!!

[@johnchiverton9375]

Great video. Really clearly explained how and why. Looking forward to watching more of your channel.

[@bugbytes3923]

Thanks a lot, that's great to hear!

[@joao-tinti]

Love it!

[@bugbytes3923]

Thanks Joao!

[@arunima2916]

covering all the related features nicely with ease, great job, expecting something for the full text search also, thank u!!!

[@bugbytes3923]

Thank you! I'll have a look into that.

[@lalomores4686]

Excellent explanation. Thanks!

[@bugbytes3923]

Thank you!

[@frankyang6943]

Thank you for your example. this is very helpful to me!

[@bugbytes3923]

You are welcome! I’m glad it was useful!

[@hakanbilgin6875]

Thank you for the video 🎉

[@bugbytes3923]

Thanks a lot mate!

[@ravikiranp7532]

Damn! This is a gold mine!

[@bugbytes3923]

Thanks!

[@samwang8500]

I appreciate your so clear and awesome tutorial!

[@bugbytes3923]

Thank you Sam. Appreciate the comment!

[@Developer_python_]

You're cool!!!! I just have thought about rest and you start to talk about it))))

[@bugbytes3923]

Thanks a lot, appreciate it!

[@laszlo.laszlo]

Very elegant solutions. Thank you!

[@bugbytes3923]

Thank you very much!

[@developer-pf2fl]

it's so helpful . Thank You so Much (Subscribed)

[@bugbytes3923]

Thanks a lot! Glad to hear that!

[@keinermendoza4631]

What an excellent explanation.

[@bugbytes3923]

Thanks a lot!

[@محمدحسناسماعیلی-خ2غ]

It was so helpful and useful and also taught simply👏 Thanks a lot 🙏😊

[@bugbytes3923]

Thank you very much, I’m glad it was useful! 👍

[@repotranstech]

Thanks for this amazing tutorial 👍.

[@bugbytes3923]

You're welcome, cheers!

[@AmoahDevLabs]

Wonderful. This is really incredible. Keep it up man. Expecting more from you on Django-Unicorn

[@bugbytes3923]

Thanks a lot man. will do!

[@RafaelHenriqueDalegraveZottess]

Nice video man, thank you!

[@bugbytes3923]

Thanks a lot, appreciate it!

[@MrThestormguy]

You are such a boss.

[@bugbytes3923]

Thanks a lot!

[@РамисСабирзянов-ъ4г]

Thanks a lot!

[@bugbytes3923]

Thanks for watching!

[@markomwandasi1447]

This is good stuff, Thanks

[@bugbytes3923]

Thanks a lot!

[@eugene_mountainland]

great stuff, thank you)

[@bugbytes3923]

You're welcome! Thanks for watching.

[@lotharhansen4170]

Thank you!

[@bugbytes3923]

you're welcome - thank you for watching! :)

[@odoolens1190]

Thanks for this!

[@bugbytes3923]

You’re welcome!

[@bmhcode]

Thanks very match it was usfule for me

[@bugbytes3923]

@@bmhcode You’re welcome - thanks for watching!

[@cyonii8683]

Great tutor

[@bugbytes3923]

Thank you!

[@ilyosbekkarshiboyev7134]

Thank you

[@bugbytes3923]

You're welcome, thanks for watching!

[@torbjornsvard5771]

Great content!. Thanks for all your high Q vids. Is it possible to search for, let's say, multiple genres?

[@bugbytes3923]

Thanks a lot, appreciated! Yes it is - I've just recorded a video that will show how to filter on multiple values. Will release this in the next few days after editing ;)

[@avindafbrz17]

thank you it was so cool and helpful. but i want to ask, i was use django admin for add the product, but the product didnt show up on the website, how to fix it?

[@maathias9]

Grate video! Let's say you want a COUNT value in the bottom of the table (or other cases you might want SUM for other purposes). Is that possible while using django-filters or is there another way to implement that with the features that comes with django-filters? I've been reading through the docs but can't seem to find a way while using django-filters. Thanks for a great channel :)

[@maathias9]

Found solution (example) If anyone else needed: In views .py - book_filter = BookFilter(request.GET, queryset=Book.objects.all()) books = book_filter.qs # Count of the books book_count = books.count() -- Include book_count in the context, then in your template include {{book_count}} where needed (maybe create a new from your table)

[@AshokSharma-hk1jc]

Hi, one confusion is that when we should specify fields in the meta class and when we can skip still confused.

[@AshokSharma-hk1jc]

Hi, One confusion that when we should specify a field in Meta class and when we can skip.

[@maathias9]

When you initially load the page, all the books gets displayed in the template. But how would you manage to have the table empty when you load the page? And only fetch the books when you filter? And if the "name" filter is empty and you click search, it then would search the entire db and fetch all the books? Thanks for your work and channel 🙏🏻

[@bugbytes3923]

Thanks for the comment! Will try and answer. For an initially empty table, you can load no books initally with: Book.objects.none() as the queryset. When you apply the filter, you can pass the params to the Book.objects.filter() function. You can prevent submitting the form with an empty name filter by adding a minimum length to the field. developer.mozilla.org/en-US/docs/Web/HTML/Attributes/minlength Note: a full-table scan over all books will occur no matter what you search for (empty string, or a certain text) unless you have an index on the Book's "name" field. Adding an index would allow much more efficient filtering over a large table.

[@maathias9]

@@bugbytes3923 Thank you for your answer. Understood how to tweak my current code a little bit. (wasn't too hard after some clarification) Again, thank you for your work💪🏼

[@antoinebuldo6356]

For me...a Big newbee its going to fast...can you help me to implement this in my crm that i created to follow my clients?

[@michaelwalker5950]

Well presented and easy to understand. I've noticed all the videos on using Django-Filter uses objects.all() to display all database records on the page on render. What if there are 1000s of records that you don't want all rendered, but only the subset displayed after filtering?

[@bugbytes3923]

Thank you Michael. To display a subset, you can use Django Pagination utilities to page the queryset that's returned after the filtering. Could fire up a quick video on this topic, if you'd like.

[@michaelwalker5950]

@@bugbytes3923 Thank you for the quick response. I actually figured it out about an hour after asking. I'm using Django-Filters and checking the dictionary if any filters are populated. If yes, display the filtered rows. If no, display nothing. So far seems to be working

[@svink312]

How to style the dropdown filter to bootstraps class (or any class) e.g. model-form. Some use Crispy Forms but it would be good to have a way to add a html class. For forms it's straight forward but for the filter generated fields+buttons I haven't manage to do it. Any tips/advice? Great video thanks for posting keep it up.

[@fikkaaps]

hey can u help me to remove the form label? thanks😊

[@sharifahmed1925]

is there a repo for this code?

[@h3ckphy246]

I would put your video on the docs instead of official documentation. Thank you.

[@bugbytes3923]

Haha thank you, kind words!

[@TomislavMiletic]

Thank you! Can you please explain why adding a content field inside of Meta class doesn't work, but adding it above does? This: import django_filters from .models import UserQuestionForLesson class QuestionsFilter(django_filters.FilterSet): content = django_filters.CharFilter(lookup_expr='icontains') class Meta: model = UserQuestionForLesson fields = [ 'is_answered', ] It is just an ordinary CharField where user types in a question for a lesson.

[@bugbytes3923]

Hi Tomislav. The content field you've defined should also work if added to the "fields" list in the Meta class (as longs as it exists as a field on your model). Does that not work? One caveat: for a CharFilter, I believe the default lookup is "exact", so there would have to be an exact match between the submitted content, and what's stored in the database for the "content" field

[@TomislavMiletic]

@@bugbytes3923 that was fast, thank you. Okay so adding a content field into Meta class doesn't work. Yes, there is a "content" charfield in the Question module, and it works if being added above the Meta class, and i used icontains, it is working. Just wanted to ask because i followed the tutorial and didn't understand why it is not working.

[@bugbytes3923]

@@TomislavMiletic I think because the default lookup is “exact”, that may be why it doesn’t work when it’s only added to Meta.fields? It works above because you override the default and use “icontains” - maybe this is the issue?

[@TomislavMiletic]

@@bugbytes3923 i will try that but that won't work for me because i don't want users to have to type the whole thing 😕 Thank you very much!

[@bugbytes3923]

@@TomislavMiletic If you want to keep the field in Meta, you can use the second of the two approaches (classes) in the code block at this link: django-filter.readthedocs.io/en/stable/ref/filterset.html#declaring-filterable-fields You can specify not only the field, but also the lookup, directly in the Meta class. Just use a dictionary, rather than a list, with dictionary values being the lookup for that field.

[@billcooper8625]

Would this work with fk? For instance, say you have a class table,student table, & student grades table in the db. In the view, you display students in a table but then with Django-filter could you apply filtering back to the grades for each student to filter the table in the view based on students with certain grades? For instance, show me student in class A and B with Grades of b or higher….

[@janisrozenbergs4226]

Great video But I am having an issue that I get a 404 every time I enter a search any suggestions for this? can share my repository if necessary :)

[@bugbytes3923]

Feel free to share, sure! I'll have a look.

[@evgeniigoncharov9507]

top

[@bugbytes3923]

Thanks!

[@zackmcnelly]

HTMX Filtering Video?

[@bugbytes3923]

I'll do a very quick demo of this in my next video!

[@amine63404]

Within your list, you are missing "Brave New World"

[@bugbytes3923]

Excellent book!

[@devopsliveuz]

source code pls?

[@elijahgathanga9831]

Well, Its a good tutorial but i don't think someone who wants to understand the concepts or how it works will get it from here.

[@bugbytes3923]

I would suggest to read the django-filter docs and work through an example on there in order to get the concepts better. Sorry this video was not useful for that!