Filter Form Table Search | Django (3.0) Crash Course Tutorials (pt 12)

Check out my Complete Django course! dub.sh/NvGboTI
Multi parameter search form with django filter form.
Follow me on Twitter: / dennisivy11
Linkedin: / dennis-ivanov
Source code + Live Demo: dennis-sourcecode.herokuapp.c...
Django Filter documentation: django-filter.readthedocs.io/...

[@DennisIvy]

Don't forget to check out my Complete Django course! dub.sh/NvGboTI

[@davidlinux]

Finally someone that is showing somewhat real world examples of a dashboard instead of the 'blog'. Really good job on this. Thank you...

[@bentwite3093]

Have not even finished watching this video... and am already excited with how you are breaking things down

[@talhashakil8245]

This filtering method was amazing !!!! You explains everything perfectly. Keep it up

[@cesarf.7587]

Dude! Thank u so much for this video. I've been looking for this since 3 weeks ago. You're a LIFESAVER!!!!! THANKSSS

[@rutviktak716]

Thanx man,only coze of ur way of teaching i'm now actually able to create my own projects🙏🏻

[@egwuemijerryjude7287]

HI Dennis, your style of teaching is so amazing, your tutorials are wonderful and helpful to beginners thanks so much, this is python django made easy.. i have been following up with the tutorial sequentially, however the pagination video pt 13 is missing, pls do us a favour to upload it soon..thank you for your great work

[@parthaprateempatra4278]

This was the thing I was wildly searching for. I need to implement something like a chain filtering to my project.

[@rayganmudberry375]

welcome back dennis. did not get the notification i had to search. anyway you rock it as always. i really appreciate you. thanks alot.

[@DennisIvy]

Thank you Raygan! It’s good to be back :)

[@network2901]

Huge respect to you for this course, it allows me to have more comprehension by real practice without waisting time, all staff i learned here i can use them very well, just this part of filtring didn't work for me, i tried severel time the same thongs you do without result, so i will appreciate really if you have time to see my code. cause i really need that ( excuse my english cause here we speak frensh).

[@Marsmac48]

Thank you so much! This series is so helpful for learning django!

[@Esteban2812]

According to the problem in 12:32: You can edit the order_form.html to fix the "Update order problem". below the {% csrf_token %} tag, you must type: {% if formset %} {{ formset.management_form }} {% for form in formset %} {{ form }} {% endfor %} {% elif form %} {{ form }} {% endif %} Hope it helps. Thanks Dennis for your videos, regards from Colombia.

[@Momentsofinsanity]

You are a godsend my guy. he never covered it again.

[@thinksmartstudios]

So what we did here is if we have a formeset, we render that, else we just render single form which other views are requesting? right?

[@Copt774]

i created a separate update form page rendering 'form', not sure if thats the best but it works

[@apingsample4720]

built in Django filters are awesome! thanks Dennis!

[@sigmadews5403]

Hi Dennis, I just wanted to tell you that your tutorials are the most useful since almost no one is covering the enterprise-level web apps. I just started with django 2 weeks ago and learned A LOT from you. Wish you all the best, I really appreciate your effort! EDIT: Does anyone know how to change the expression 'contains' on the front page to something else (translation to another language/delete it...) at the field with lookup_expr='icontains' ?

[@diegohuareza.2488]

Use-> date = CharFilter(field_name="date", lookup_expr='icontains', label="ITS_######FREE_TEXT") , with label edit labeltext

[@hamza-325]

For the people who want to search by the name of the product by typing, without adding the notes as he did, you can just add this line: product_name = CharFilter(field_name='product__name', lookup_expr='icontains') to the OrderFilter, and add 'product' to the list of exclude.

[@bimosyahsiraj219]

Hello sir,can you explain why field_name should be 'product__name'? I mean I don't see any field with name 'product__name'. Have a good day sir!

[@electricimpulsetoprogramming]

@Hamza Abbad could you answer him?

[@hamza-325]

'procduct__name' is a built-in feature in Django, it simply means the attribute 'name' of the object product. It has been a very long time since I put this comment so I don't remember what is in this video. I am not even programming a lot in Django these days.

[@polarization-0]

the double underscore (__) means that we are accessing a parent-chield relationship. product__name means, we are accessing through our "Order" model, but we are accessing the attribute product (from the Order model) and then accessing the "name" attribute from Product model.

[@sannjayy]

Thanks a ton man...

[@SreebashDasFitness]

Thank you so much dear! We need more advanced projects also.

[@samandarshoyimov5580]

Thanks Dennis. I have been learning a lot from you

[@user-qv7rw7dq1d]

This is amazing. Concise and to the point. I have a question though... Where the heck do you apply styling to the django_filters form elements?! I'm trying to locate it so that I can make it match my bootstrap styling. Also, how do you order which form comes up first? I have the contains form all the way last and that is bothering me. Thank you 5/5 !

[@TjaartSwanepoel]

Thanks again for the series, just missing the pagination video, please consider including it

[@smit764]

Hi Dennis, Thanks for the tutorials, it's very helpful for me I have a question about ModelForms How can I customize FormSet, Form & Filter by using bootstrap

[@oleksandrdiadiushenko4971]

Hi, Dennis! Thanks for awesome tutorial! Can we exclude some item from choise list in product or status form for example?

[@frankking5326]

Always amazing content and easy to follow! Thanks

[@akinyelewilliamo.617]

Hi Dennis. Thank you for this tutorial. It’s really been helpful. I can’t seem to find the part 13 of this series. Kindly help pls. Thank you.

[@siddhantsharma8454]

thank you so much, searched everywhere for this

[@mengpao86]

Hi Dennis, love your videos and it helps me alot in my learning. However, I cant seem to find the next video (pt13) in the playlist nor in your video list..Has it been taken down already or ?

[@khadimhusen]

Nice, Video, I need tthis filter for exclude value. is there and option in this django-filter module for this purpose.?

[@jadynchowdhury680]

Hi Dennis. Amazing videos. How would you apply a search for a customer ID, not just name. As it is possible that customers may have the same names

[@paulohsgoes1959]

Excellent job. Congrats!

[@theblackelephant]

i love the way you teach

[@prabinsinghkhetwal1317]

In this video you have told in the end that next video will be for pagination, however that video is not there, I.e video no. 13 is missing it seems.

[@abdulazizshokirov7386]

Hi Dennis, thankyou for this amazing teaching. Bro, it seems to me I can't find pt13 related to pagination. Can you share it also? Thank you again for your effort!

[@navyarg209]

Hey Dennis, Is there a way to sort querysets using django-filter??

[@lukasmodric3063]

Do you know how to change te appearance of the django-filter field ? Pelease help me.

[@bernardvandenberg2209]

Hi Dennis. Thanks for the tutorials. They are very good. I am not able to get your next Tutorial (pt 13). It seems to be lost. Can you load it again?

[@dradrigapatrick]

I got the error while running this topic "Filter Form Table Search" following your work So i dont if there is a change in pip 20.2.3 and django 3.1.1

[@kfootballkid]

Are there any concerns for SQL injection when your search parameters are displayed in the URL?

[@polarization-0]

In the lookup expression, 'icontains' does not "exclude case sensitivity". It checks whether the characters I'm searching with, are present in that particular field or not.

[@nicholassmith6412]

Such useful videos, thanks so much for making these

[@abhishekgourav6144]

The form is not rendering when i give {{myFilter.form}} although i did cross check if i made any mistake by removing .form from myFilter and its just not rendering the form

[@pallyweb]

Hi Dennis , hope you are doing well. At the end of this tutorial you mentioned about "pagination" tutorial (pt13) . I can't find that specific tutorial among all your videos. Please update regarding it. Thanks :)

[@patricklam18]

Great Video. Very expecting to next.

[@darkamv457]

hey man, how i can change the lenguaje to spanish in the 'lookup_expr' i want change the 'is greater than ' to ' es posterior a'

[@adosntobondombasi7670]

hello I would like to filter dynamically data, as when we are in a social network it is our own data that is displayed can you help me please?

[@dobrildobrilov6368]

Hello Dennis, how can I change date input_format for the start_date filter to day/month/year , because currently it accept only month/day/year? I know it can be done by settings.py -> DATETIME_INPUT_FORMATS , but then this will apply for the whole project. I need just be able to apply such input_format only for start_date field.

[@sdtk9635]

Thank you very much for this video, helped a lot

[@kis_codes]

hi Dennis i cant seem to get the source code for the register.html. please is there anywhere i can get it?

[@ankurtiwari5664]

how can i add calender in start_date and end_date field to pick date,instead of writing whole

[@mahammadhusaim]

hello sir after applying filter how to style it i mean how to apply css or boostrap class on filter box like textbox or other filter fieldset

[@dradrigapatrick]

Hey, I have solved after reading through the documentation over and over again. Thanks still.

[@jimmycala]

Thanks a lot!! But I'm having troubles with ForeignKey... I just can see the ID labels like Model Object (1), Model Object (2), Model Object (3)....Model Object (16). But the filter actually works.

[@louismefor9539]

Thank you dennis this is awsome!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@thesumitsingh1234]

I have a table which has nearly hundred thousand rows. Everytime a user will search, the entire database will be searched, which will consume server processing power. How can I add some sort of cache feature so that the search results are stored and lesser CPU resources are consumed? (since I expect a lot of users to be using it simultaneously)

[@CRYSTALXO24]

How can I change field_name contains: that comes with the {{ django_filter }} inside my html??

[@avadhootshinde1150]

when note added to manage.py order class and run command makemigrations but it says no migrations detected. Any on can help??

[@sumnanazadi]

Hi, What if I only want to show data after clicking the SEARCH button. Before that, I don't want to show any table data.

[@i701Dev]

How do i go about styling the fields with css? If anyone knows please tell me

[@parneetisood2728]

How can I add calendar/date picker in the Date field..?

[@barnabascharumbuka6744]

hi Dennis How can i export the filtered data.

[@beatrizgomes8077]

Man, I love you so much! Thank you for that.

[@rachanagupta6705]

Hi Dennis, When I am trying using django_filters, I am getting following error: AttributeError: module 'django_filters' has no attribute 'FilterSet'. Please help me.

[@WA232010]

Hello when I try this tutorial in my App, my all page refresh when I click on Search Because in my app I have a tabs, this tabs getting pages so What you did to don't refresh the page. ? thank you

[@ujjwalsaxena6469]

lookup_expr="lte", is not working as you said, it return the orders which are lesser than the date but not on that day. Do you know why is this happening.

[@programmer7606]

can we shorten " Date created is greater than or equal to" ?

[@francineamberfortes4138]

hi the update does not work i dont know why can you help me this?

[@fatimamalik3211]

I'm getting error when I try to add django-filters in installed apps... Please help

[@nakhan69]

Hi Dennis what I learn form you as a beginner, I did not learn in school. Thank you. You are the CHAM

[@adeleoolab8633]

@dennis Ivy Thanks so much for your well made video and all these information. is it possible to use the code you provided in this video in my Project ? Thanks

[@anushribarsaiyan8302]

hi sir i am using ubantu if install filter its given this error 'Package 'django-filter' has no installation candidate' please help me

[@mahderzergaw3918]

idk y but the filter filed are not displaying i only see the search button please anyone tell...

[@mayankgupta6542]

Your tutorial is great!! Helped ,me a lot. Can you help me to sort data liked we filter it based on model fields?

[@themousepotato8257]

Hello, thank you for your tutorial can you guide how to redirect search results, I want search results displaying in another page

[@kken8766]

Hi, I have been following along the tutorial and notice that part 13 is missing. Great Video

[@Will29295]

YES!!!! WHY IS IT MISSING!?

[@Jjolasman]

where is the pagination video? is not in your playlist :/

[@TechnologyTipsTricks]

Please tell me how to create a weekly-filter and monthly-filter ???

[@onlinetimenow1647]

any tutorial on dependant drop-down select like category-->subcategory or country-->province-->city using pure Django and maybe jquery would be appreciated(no third party for learning and understanding reason how things work)! i looked what is available on the internet and tried but not working! any step by step from creating model to view and modelForm would be nice.

[@arek9430]

I have question, what if I wanted to filter order.product.name ? How to acces this in field_name? Maybe there is different apporach? Thanks for the video and whole series.

[@absoluteabout3981]

So far, so great Pagination !! please😀

[@roderickdanzing1414]

ive been following this tut and part 13 is missing and i encountered a lot of error..please upload part 13 tnx

[@tabraizcreation7689]

Hi Dennis, Please help me solve these as I'm following your series 1. By adding a new field into the model now I can't update them 2. Navigating to the next page if the product count is greater than 5 3. How can I reset the search form ??? although I'm grateful that you thought about lectures for the latest Django version

[@nhfx2261]

Where is 13th Tutorial, Please give me the link of 13th video if anyone have that

[@owaisbashir26]

Buddy my order form is an empty object Could u guide plz?

[@JP-zq2js]

wow!!!!just awesome man!!!!

[@Numbersss]

How to do this with a class based list view ?

[@nihirshah4752]

I want to display parent class data how can I do that???

[@sabrinatahir3545]

{{myFilter.form}} is not working for me .. it doesn't show any form ... what to do?

[@NeerajExplores]

Great job bro

[@ashleyadrias]

Great Tuto! I made a quick change to the order_form.html to made into account the switch between formset (creating new orders) and forms (updating previous orders)... Im a newbie but is this a way you would do it? {% csrf_token %} {% if formset.management_form %} {{ formset.management_form }} {% for form in formset %} {{form}} {% endfor %} {% else %} {{form}} {% endif %} Thanks again for your help!!

[@hammadyasir2174]

SIR lecture number 13 are missing kindly sir upload it

[@kuwingderazen7539]

can use 3.1version?

[@zokirgofurboyev220]

You are great. Thank you very much

[@valerapelenskiy5015]

hi, thank you for your amazing tutorials. I'd like to ask you to make a lesson about Django-Tables2 or other data tables with filtering, sorting, paginations. With the ability to select all rows and do some actions with selected rows. Imagine that you have 50,000 products or more and you need to import them into a file or change the status for everyone.

[@Isha7558]

i need it now

[@nsnilesh604]

How to get multiple selection in filter

[@nourhacker3734]

Hi Dennis, Thanks for the tutorials, they are very helpful! I was wondering about "lecture 13", I think you forgot to upload it. Is it so or you are still working on it?

[@davidbrown2806]

I looked at the future code in the repository, and it does not appear that there is any pagination code. I could be wrong, but that's how I see it.

[@sharifahmed1925]

Hi Dennis. I've followed your tutorial on the filtering but my filters don't have the drop down as yours do. Instead I have to type in the values of the field I want to search for. Any idea how to get the drop down select functionality??

[@zadilkhwaja]

Did u get solution

[@francineamberfortes4138]

NoReverseMatch at / Reverse for 'create_order' with no arguments not found. 1 pattern(s) tried: ['create_order/(?P[^/]+)/$'] hi can you help me fix this?

[@60secwithMalikHamza]

sir my search button not working or my orders not filtering plzzz kindly help

[@dahichhole]

How to add css in form?

[@jacodevilliers1937]

Thanks Dennis!

[@user-qv7rw7dq1d]

Awesome. Thank you!