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.
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.
'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.
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.
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
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' ?
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
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?
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
@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.
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).
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.
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
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.
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.
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 ?
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
@@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!
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!
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.
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.
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')
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')
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 :)
For all those with the attribute error, kindly ensure you use Sentencecase for the .FilterSet argument as in class ModelFilter(django_filters.FilterSet): pass
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!!
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 !
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!
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??
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.
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.
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
@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
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...
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 dennisivy11@gmail.com and I’ll take a look
@@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
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.
In my database model, I have a column called 'jobtitle'. When I display it in the filter form, it appears as 'Jobtitle contains:'. I want it to appear as 'Job Role Title contains:', how to do it without changing the name in the model (since it can't contain spaces in the model definition)?
You can try something like this: Product: {{ myFilter.form.product }} Status: {{ myFilter.form.status }} Date created GTE >=: {{ myFilter.form.start_date }} Date created LTE
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.
@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.
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']
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
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)
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.
hi Dennis. I really like django-filter. But how can i customize form, I don't like default django-filter form. I created new form search but long code, because i have to get by name. Thanks!
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
Anyone else have issues importing django_filters? I can't seem to get it working, dispite pip-ing to my heart's content. EDIT - SOLVED!! The django_filters library doesn't work with django >3.0 so I had to downgrade to Django 3.0 by running: pip install "Django=3.0" --force-reinstall
Hi Dennis, I have a question regarding this tutorial of yours, I followed all your instructions but it seems I can't filter my data. I'm using data table, is that a concern why my filter won't work (note: when I click "search" nothing happens, it has no also error message)? Thank you sir
hi Vanjo, did you solve the error you mentioned? If not, check if for the Search button in your customer.html shows correctly. I had the same error and it was because there was a type - "from" instead of "form"
Don't forget to check out my Complete Django course! dub.sh/NvGboTI
Finally someone that is showing somewhat real world examples of a dashboard instead of the 'blog'. Really good job on this. Thank you...
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.
You are a godsend my guy. he never covered it again.
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?
i created a separate update form page rendering 'form', not sure if thats the best but it works
Have not even finished watching this video... and am already excited with how you are breaking things down
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.
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!
@Hamza Abbad could you answer him?
'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.
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.
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
good
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' ?
Use-> date = CharFilter(field_name="date", lookup_expr='icontains', label="ITS_######FREE_TEXT") , with label edit labeltext
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
Thanx man,only coze of ur way of teaching i'm now actually able to create my own projects🙏🏻
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?
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.
This filtering method was amazing !!!! You explains everything perfectly. Keep it up
Dude! Thank u so much for this video. I've been looking for this since 3 weeks ago. You're a LIFESAVER!!!!! THANKSSS
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
Thanks a ton man...
Hi, I have been following along the tutorial and notice that part 13 is missing.
Great Video
YES!!!! WHY IS IT MISSING!?
@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.
it still not working !! any help?
This was the thing I was wildly searching for. I need to implement something like a chain filtering to my project.
welcome back dennis. did not get the notification i had to search. anyway you rock it as always. i really appreciate you. thanks alot.
Thank you Raygan! It’s good to be back :)
Thanks again for the series, just missing the pagination video, please consider including it
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).
thank you so much, searched everywhere for this
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.
Thank you so much! This series is so helpful for learning django!
built in Django filters are awesome! thanks Dennis!
nice sir ple give solution for the drop down that includes a "-----" replace with placeholder
But what would be written in this placeholder?
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.
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.
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
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
Can you implement a date-picker in the date input fields?
I’ll do this in its own video. Many different ways to accomplish this.
@@DennisIvy Thanks Man!
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.
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.
i need it now
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 ?
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
Hi Mourad , were u able to do that? Thanks in Advance
@@walterrandazzo6399 no but i changed the labels using JavaScript in the html page
@@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!
i love the way you teach
Thank you so much dear! We need more advanced projects also.
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?
Thanks Dennis. I have been learning a lot from you
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!
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.
It is working. Thanks man
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.
Nice, Video,
I need tthis filter for exclude value.
is there and option in this django-filter module for this purpose.?
Great Video. Very expecting to next.
Hello Dennis, How can I change 'Date created is greater than or equal to: ' to simply 'Start Date: ' ?
Thank You!
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')
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')
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 :)
For all those with the attribute error, kindly ensure you use Sentencecase for the .FilterSet argument as in
class ModelFilter(django_filters.FilterSet):
pass
That still doesn't solve the problem.
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!!
Hi, Dennis! Thanks for awesome tutorial!
Can we exclude some item from choise list in product or status form for example?
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 !
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!
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??
Did u get solution
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.
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.
Hey Dennis,
Is there a way to sort querysets using django-filter??
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
Hi Dennis what I learn form you as a beginner, I did not learn in school. Thank you. You are the CHAM
Hello, thank you for your tutorial
can you guide how to redirect search results, I want search results displaying in another page
@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
How do you style the filter-form components? (for example, how would I add padding between 'Customer' and the colon)
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...
Hi, I tried the same way you did but its showing error. The error is :No module named 'django-filters'. What should I do?
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 dennisivy11@gmail.com and I’ll take a look
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
So now it’s just a configuration error. Is it in installed apps?
@@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
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.
Are there any concerns for SQL injection when your search parameters are displayed in the URL?
Excellent job. Congrats!
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.
How can I change field_name contains: that comes with the {{ django_filter }} inside my html??
hi Dennis i cant seem to get the source code for the register.html. please is there anywhere i can get it?
In my database model, I have a column called 'jobtitle'. When I display it in the filter form, it appears as 'Jobtitle contains:'. I want it to appear as 'Job Role Title contains:', how to do it without changing the name in the model (since it can't contain spaces in the model definition)?
Something like this should do:
Jobtitle = django_filters.CharField(field_name='Job Role')
You can try something like this:
Product: {{ myFilter.form.product }}
Status: {{ myFilter.form.status }}
Date created GTE >=: {{ myFilter.form.start_date }}
Date created LTE
Always amazing content and easy to follow! Thanks
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.
I'm getting error when I try to add django-filters in installed apps... Please help
SIR lecture number 13 are missing kindly sir upload it
@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.
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']
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']
Hey, I have solved after reading through the documentation over and over again.
Thanks still.
sir it would be nice to make a tutorial about django-filter + ajax table like if filter happend the page will not refresh
Thank you very much for this video, helped a lot
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?
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'
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
I don't know how to Thank you enough
Do you know how to change te appearance of the django-filter field ? Pelease help me.
Please tell me how to create a weekly-filter and monthly-filter ???
It said error none type attribute on 5:34
Great job bro
Help me Dennis, when I pass {{myFilter.form}} to customer template, I got TypeError __str__ returned non-string (type NoneType)
check what's inside in your dunder or magic method what "value" it returns. You need to specify correctly.
So far, so great
Pagination !! please😀
hi Dennis
How can i export the filtered data.
Such useful videos, thanks so much for making these
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)
Your tutorial is great!! Helped ,me a lot. Can you help me to sort data liked we filter it based on model fields?
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.
hi Dennis. I really like django-filter. But how can i customize form, I don't like default django-filter form. I created new form search but long code, because i have to get by name. Thanks!
I find the way to customize django-filter form by using third-party : django-widget-tweaks to render_fields. Thanks Dennis so much!
How can I add calendar/date picker in the Date field..?
where is the pagination video? is not in your playlist :/
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
Anyone else have issues importing django_filters? I can't seem to get it working, dispite pip-ing to my heart's content.
EDIT - SOLVED!! The django_filters library doesn't work with django >3.0 so I had to downgrade to Django 3.0 by running:
pip install "Django=3.0" --force-reinstall
I have downgraded to 3.0 still not working
@@RaviShankarvirat have you fixed it? I am encountering the same issue
@@juliuserictuliao5212 Ya i have fixed it.Please let me know what error you are receiving
You are a great guy. God bless you Guruji.
Thank you Sager :)
can we shorten " Date created is greater than or equal to" ?
Hi Dennis, I have a question regarding this tutorial of yours, I followed all your instructions but it seems I can't filter my data. I'm using data table, is that a concern why my filter won't work (note: when I click "search" nothing happens, it has no also error message)? Thank you sir
hi Vanjo, did you solve the error you mentioned? If not, check if for the Search button in your customer.html shows correctly. I had the same error and it was because there was a type - "from" instead of "form"
@@misasato256 Hello, I still have this error. I also check the spelling and there is no typo. Don't know what to do -_-
Man, I love you so much! Thank you for that.
Thank you dennis this is awsome!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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.
This a great series. Unfortunately part 13 is Missing. please fix that. Thanks
Did u get that part 13
It's been 2 years