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

[@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...

[@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

[@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.

[@bentwite3093]

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

[@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

[@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

[@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

[@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 :)

[@talhashakil8245]

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

[@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.

[@venkatrao235]

nice sir ple give solution for the drop down that includes a "-----" replace with placeholder

[@electricimpulsetoprogramming]

But what would be written in this placeholder?

[@felreizmeshinca7459]

@1:10 you can use "python -m pip install django-filter" if you have an error when trying to run the server. The error is: ModuleNotFoundError: No module named 'django_filters' This is because the pip script you are running is not installing modules for the interpreter that the python command is using.

[@tayssir3668]

it still not working !! any help?

[@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

[@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.

[@sannjayy]

Thanks a ton man...

[@TjaartSwanepoel]

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

[@mahmudsajib8648]

Can you implement a date-picker in the date input fields?

[@DennisIvy]

I’ll do this in its own video. Many different ways to accomplish this.

[@mahmudsajib8648]

@@DennisIvy Thanks Man!

[@Marsmac48]

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

[@kken8766]

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

[@Will29295]

YES!!!! WHY IS IT MISSING!?

[@parthaprateempatra4278]

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

[@siddhantsharma8454]

thank you so much, searched everywhere for this

[@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.

[@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?

[@vallaryayuko9335]

This crash course has taught me a lot. Where can i get the source code, i have been following through but I may have missed something and i was using the tutorials to do my end of semester project. The link provided is broken. Thank you so much Dennis for the great work.

[@apingsample4720]

built in Django filters are awesome! thanks Dennis!

[@themousepotato8257]

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

[@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.

[@samandarshoyimov5580]

Thanks Dennis. I have been learning a lot from you

[@janbertcampos]

sir it would be nice to make a tutorial about django-filter + ajax table like if filter happend the page will not refresh

[@mouradboukroun2696]

Hi dennis Thanks a lot for this tuto, but i wanna ask how to customize the name of fields in search section and remove words added by django like Date created is greater than or equal to and Note contains.... Thank you

[@walterrandazzo6399]

Hi Mourad , were u able to do that? Thanks in Advance

[@mouradboukroun2696]

@@walterrandazzo6399 no but i changed the labels using JavaScript in the html page

[@walterrandazzo6399]

@@mouradboukroun2696 ok dude thx 4 the reply! I have changed them using verbose_name parameter in the model definition. I can you u the code if u want. Can u share you js code to me? Thanks in advance!

[@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 ?

[@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!

[@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

[@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.

[@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 :)

[@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).

[@theblackelephant]

i love the way you teach

[@triders]

Wanted to notice one issue: we based "update" button on "create_order" functionality, so after this lesson when i push it it shows nothing. Because to update any order we still sending 'form' but in new template for "create_order" we don't render {{form}} any more (we render {{formset}}). So it can be fixed realy quick: we need to create "update_order.html" template (which is a copy of "create_order" but with only {{form}}). Thanx for another cool video, by the way!

[@samueloffem5519]

I noticed Dennis Ivy didn't solve the issue and I did exactly as said in this comment. But I still have an error.. On the browser the error is: TypeError at /update_order/1 returned type non-string (type NoneType) On the console I get the error: ProgrammingERROR: Cannot operate on a closed database. Pls help I'm stuck.

[@bhavikjain1077]

It is working. Thanks man

[@hammadyasir2174]

SIR lecture number 13 are missing kindly sir upload it

[@kis_codes]

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

[@clearthinking5441]

How do you style the filter-form components? (for example, how would I add padding between 'Customer' and the colon)

[@clearthinking5441]

for your projects do you tend to build your own filters from scratch rather than using 'django-filters'? I find 'django-filters' quite hard to customize using bootstrap...

[@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.

[@fatimamalik3211]

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

[@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

[@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?

[@oleksandrdiadiushenko4971]

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

[@TechnologyTipsTricks]

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

[@SreebashDasFitness]

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

[@parneetisood2728]

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

[@cesaralvarez9436]

Hello Dennis, How can I change 'Date created is greater than or equal to: ' to simply 'Start Date: ' ? Thank You!

[@continental_drift]

documentation django-filter.readthedocs.io/en/master/ref/filters.html#label , there is no example. In filters.py change the following two lines. start_date = DateFilter(field_name="date_created", lookup_expr='gte', label='Start Date') end_date = DateFilter(field_name="date_created", lookup_expr='lte', label='End Date')

[@Opwins73]

In case anyone is still wondering, you add the label parameter to DateFilter like so: start_date = DateFilter(field_name="date_created", lookup_expr='gte', label='Start Date')

[@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!!

[@patricklam18]

Great Video. Very expecting to next.

[@uzojames5254]

For all those with the attribute error, kindly ensure you use Sentencecase for the .FilterSet argument as in class ModelFilter(django_filters.FilterSet): pass

[@beefykenny]

That still doesn't solve the problem.

[@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

[@Numbersss]

How to do this with a class based list view ?

[@rajeshkumarrout5691]

Hi, I tried the same way you did but its showing error. The error is :No module named 'django-filters'. What should I do?

[@DennisIvy]

First check to make sure you installed Django filters via pip install. If that’s done then you probably forgot to add it to installed apps. Send your source code to [e-mail] and I’ll take a look

[@rajeshkumarrout5691]

pip freeze : asgiref==3.2.3 beautifulsoup4==4.8.2 bootstrap4==0.1.0 cffi==1.13.2 Django==3.0.2 django-bootstrap4==1.1.1 django-braces==1.14.0 django-filter==2.2.0 django-filters==0.2.1 misaka==2.1.1 pkg-resources==0.0.0 pycparser==2.19 pytz==2019.3 six==1.13.0 soupsieve==1.9.5 sqlparse==0.3.0

[@DennisIvy]

So now it’s just a configuration error. Is it in installed apps?

[@rajeshkumarrout5691]

@@DennisIvy It's got solved. But I have one problem . I have made a social site project where I have used some built in Views and because of that I am not able to figure it out , how should I set myFIilter statement and the context statement. Should I send my views.py Code to you ? I really need your help

[@DennisIvy]

Sure send it over to my email and I’ll take a look when I have a second. It’s not much different with classed based views.

[@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

[@elonmusk2142]

who couldn't fix update function in the dashboard you should: create new update_order.html as in 10 th lessons order_form .html in def updateOrder() you should render it to update_order.html

[@nsnilesh604]

How to get multiple selection in filter

[@johnjim3741]

What happened to part 13?

[@looyeeng9946]

0:01 Intro 0:58 Filter Installation 1:38 Create Filter Form 3:36 Rendering Filter Form 8:20 Date Range Filter Note: www.notion.so/12-Filter-Form-Table-Search-f6c316bdb37741c785bff1f642637056

[@cmj3153]

good

[@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'

[@i701Dev]

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

[@tilting_cat3344]

It said error none type attribute on 5:34

[@alphaxardnganga945]

This a great series. Unfortunately part 13 is Missing. please fix that. Thanks

[@midhunskani]

Did u get that part 13

[@midhunskani]

It's been 2 years

[@frankking5326]

Always amazing content and easy to follow! Thanks

[@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

[@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

[@nakhan69]

I don't know how to Thank you enough

[@sdtk9635]

Thank you very much for this video, helped a lot

[@navyarg209]

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

[@roderickdanzing1414]

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

[@lukasmodric3063]

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

[@programmer7606]

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

[@khadimhusen]

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

[@kuwingderazen7539]

can use 3.1version?

[@backupphotos4730]

You didn't mention to add forms tag initially

[@nakhan69]

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

[@francineamberfortes4138]

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

[@owaisbashir26]

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

[@9449365005]

same here I have tried installing the Django-filter with pip and then added the reference to settings but inspire of that I am getting the error unresolved import django_filters due to which I am not able to implement search

[@sabasiddika]

do you figure it out?

[@nhfx2261]

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

[@CRYSTALXO24]

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

[@jmmacatangay_grizzlybear]

where is your #13 series? It's missing

[@DennisIvy]

It was supposed to be pagination but I haven't made the time to add it yet.

[@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.

[@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)

[@nihirshah4752]

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

[@Jjolasman]

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

[@absoluteabout3981]

So far, so great Pagination !! please😀

[@forgedtech5074]

ughhh this isn't working with 3.1 it seems.. i really need to know this, will post if i find a solution, thanks for your help so far dennis!

[@ujjwalsaxena6469]

Hey man, I have some similar questions, So if you find the solution could you please answer what I posted here -> stackoverflow.com/questions/63509915/how-edit-names-of-field-in-django-filters-and-add-styling.

[@barnabascharumbuka6744]

hi Dennis How can i export the filtered data.

[@nicholassmith6412]

Such useful videos, thanks so much for making these

[@paulohsgoes1959]

Excellent job. Congrats!

[@doniyorabduvokhidov1706]

Part 13 is missing Please....

[@akashpushkar306]

@Dennis Ivy: Thanks for such amazing sessions. Really helpful. Circulated in my network. Need one help while applying filtering. I just see 'Search' button. I am not able to see model columns as dropdown.

[@akashpushkar306]

view.py import django_filters from .models import SalesReport from .models import * class SalesReportFilter(django_filters.FilterSet): class Meta: model = SalesReport fields = '__all__' exclude = ['sales']

[@akashpushkar306]

model.py class SalesReport(models.Model): month = models.IntegerField() sales = models.FloatField() product = models.CharField(max_length= 25) def __str__(self): return self.month ********************************** myFilter = SalesReportFilter() context = {'myFilter':myFilter} *********************************** sales.html {{myFilter.form}} Search {% load chartit %} {{ chart_list|load_charts:"cht, cht2" }} ********************************* view.py from django.shortcuts import render from django.http import HttpResponse from .models import SalesReport, MonthlyWeatherByCity, SalesHistory from chartit import DataPool, Chart, PivotDataPool, PivotChart from django.db.models import Avg, Sum, Count, Min, Max from .filters import SalesReportFilter def home(request): first_graph = "My First django_chartit graph" return HttpResponse(first_graph) def sales(request): sales = DataPool( series= [{'options': { # 'source': SalesReport.objects.all()}, 'source': SalesReport}, #'source': SalesReport.objects.filter(sales__lte=10.00)}, #lte means less than equal 'terms': [{'month': 'month', 'sales': 'sales'}] }, ]) def monthname(month_num): names = {1: 'Jan', 2: 'Feb', 3: 'Mar', 4: 'Apr', 5: 'May', 6: 'Jun', 7: 'Jul', 8: 'Aug', 9: 'Sep', 10: 'Oct', 11: 'Nov', 12: 'Dec'} return names[month_num] #Step 2: Create the Chart object cht = Chart( datasource = sales, series_options = [{'options':{ 'type': 'column', 'stacking': False}, 'terms':{ 'month': [ 'sales'] }}], chart_options = {'title': { 'text': 'Sales Amounts Over Months'}, 'xAxis': { 'title':{'text': 'Sales Total'}}, 'yAxis': { 'title': {'text': 'Month Number'}}, 'legend': { 'enabled': True}, 'credits': { 'enabled': True}}, x_sortf_mapf_mts=(None, monthname, False)) #Step 3: Create a second chart object cht2 = Chart( datasource = sales, series_options = [{'options':{ 'type': 'pie', 'plotBorderWidth': 1, 'zoomType': 'xy', 'legend':{ 'enabled': True, }}, 'terms':{ 'month': [ 'sales'] }}], chart_options = {'title': { 'text': 'Sales Amounts Over Months - Pie Chart'}, 'xAxis': { 'title':{'text': 'Sales Total'}}, 'yAxis': { 'title': {'text': 'Month Number'}}, 'legend': { 'enabled': True}, 'credits': { 'enabled': True}}, x_sortf_mapf_mts=(None, monthname, False)) myFilter = SalesReportFilter() context = {'myFilter':myFilter} #Step 4: Send the chart object to the template. return render(request,'sales.html', {'chart_list': [cht, cht2]}) ********************************** filters.py import django_filters from .models import SalesReport from django_filters import DateFilter, CharFilter from .models import * class SalesReportFilter(django_filters.FilterSet): class Meta: model = SalesReport fields = '__all__' exclude = ['sales']

[@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.

[@kfootballkid]

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