Dear Suthar,
Your idea works well , but I want now to display the result on chart. Below
is the code I am trying to use:
but Am getting the error message:
Exception Value:
Object of type date is not JSON serializable
def reqChart(request):
aa = Customer_Requests.objects.values("arrival_date").annotate(num_req=Count
("request_name")).order_by('-arrival_date')[:20:-1]
print(aa)
datesb = list()
sumdata = list()
for dd in aa:
datesb.append(dd['arrival_date'])
sumdata.append(dd['num_req'])
arriva_days = {
'name': 'Datess',
'data': sumdata,
'color': 'green'
}
chart3 = {
'chart': {'type': 'column'},
'title': {'text': 'Previous statistics'},
'xAxis': {'datesb': datesb},
'series': [arriva_days]
}
dump3 = json.dumps(chart3)
return render(request,'summarizedchart.html',{'chart3': dump3})
Please once again
regards,
On Thu, 3 Jun 2021 at 09:00, lalit suthar <sutharlalit...@gmail.com> wrote:
> this will do
>
> Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name")).order_by("-id")[:30:-1]
>
> On Thursday, 3 June 2021 at 11:37:26 UTC+5:30 abubak...@gmail.com wrote:
>
>> to display last 30 records you can write your code like this:
>> Customer_Requests.objects.all()[-30]
>>
>> On Thu, Jun 3, 2021 at 10:51 AM Eugene TUYIZERE <eugenet...@gmail.com>
>> wrote:
>>
>>> Dear Latit,
>>>
>>> Thank you very much. Now how can I display 30 last records? Regardless
>>> of how many records I may have ! Just the last 30 records!
>>>
>>> Thank you
>>>
>>> On Thu, 3 Jun 2021 at 06:51, Lalit Suthar <sutharl...@gmail.com> wrote:
>>>
>>>> > in brief, I want to transform this query in django query
>>>> this will be equivalent to this query in django
>>>>
>>>> Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name"))
>>>>
>>>>
>>>> On Thu, 3 Jun 2021 at 02:02, Eugene TUYIZERE <eugenet...@gmail.com>
>>>> wrote:
>>>>
>>>>> in brief, I want to transform this query in django query
>>>>>
>>>>> [image: image.png]
>>>>>
>>>>> On Wed, 2 Jun 2021 at 21:56, Eugene TUYIZERE <eugenet...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Dear Sebatian,
>>>>>>
>>>>>> This is what I get:
>>>>>>
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-03 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-04 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-05 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-06 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-07 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-08 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-09 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-10 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-11 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-12 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-13 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-14 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-15 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-16 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-17 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-18 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-19 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-20 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-21 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-22 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-23 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-24 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-25 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-26 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-27 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-28 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-29 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-30 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-05-31 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-06-01 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>> SELECT `crms_customer_requests`.`arrival_date`,
>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM
>>>>>> `crms_customer_requests` WHERE `crms_customer_requests`.`arrival_date` >=
>>>>>> 2021-06-02 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL
>>>>>>
>>>>>> On Wed, 2 Jun 2021 at 21:53, Sebastian Jung <sebasti...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Eugene,
>>>>>>>
>>>>>>> Please make Print(report.query) then you get SQL querys and Most of
>>>>>>> time i get an Idea what's wrong
>>>>>>>
>>>>>>> Regards
>>>>>>>
>>>>>>> Eugene TUYIZERE <eugenet...@gmail.com> schrieb am Mi., 2. Juni
>>>>>>> 2021, 21:41:
>>>>>>>
>>>>>>>> Dear Team,
>>>>>>>>
>>>>>>>> I need help. I am working on a project where one of the tables is
>>>>>>>> about requests. I want to have a report of the number of requests on
>>>>>>>> each
>>>>>>>> day in the last 30 days, something like this:
>>>>>>>> [image: image.png]I I used the code below just before displaying
>>>>>>>> on the chart but the code gives me wrong information
>>>>>>>>
>>>>>>>> def reqChart(request):
>>>>>>>> current_date = date.today()
>>>>>>>> days_before = date.today()-timedelta(days=30)
>>>>>>>> for dt in daterange(days_before,current_date):
>>>>>>>> reports = Customer_Requests.objects.filter(arrival_date__gte=dt).\
>>>>>>>> extra({'day':"date(arrival_date)"}).\
>>>>>>>> values('arrival_date').annotate(count=Count('request_name'))
>>>>>>>> print(reports)
>>>>>>>>
>>>>>>>>
>>>>>>>> And I need help
>>>>>>>> --
>>>>>>>> *TUYIZERE Eugene*
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> *Msc Degree in Mathematical Science*
>>>>>>>>
>>>>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
>>>>>>>> Garden-Lime, Cameroon*
>>>>>>>>
>>>>>>>> Bsc in Computer Science
>>>>>>>>
>>>>>>>> *UR-Nyagatare Campus*
>>>>>>>>
>>>>>>>> Email: eugene....@aims-cameroon.org
>>>>>>>> eugenet...@gmail.com
>>>>>>>>
>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38
>>>>>>>>
>>>>>>>> --
>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>> Groups "Django users" group.
>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>> send an email to django-users...@googlegroups.com.
>>>>>>>> To view this discussion on the web visit
>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHstWyfMVKQhJb%3DxGKff3p3V%2BFQ_w3DkYVpOe-pEW2ySKg%40mail.gmail.com
>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHstWyfMVKQhJb%3DxGKff3p3V%2BFQ_w3DkYVpOe-pEW2ySKg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>>>> .
>>>>>>>>
>>>>>>> --
>>>>>>> You received this message because you are subscribed to the Google
>>>>>>> Groups "Django users" group.
>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>> send an email to django-users...@googlegroups.com.
>>>>>>> To view this discussion on the web visit
>>>>>>> https://groups.google.com/d/msgid/django-users/CAKGT9myp4HU6%2BZo6d-JqeaTPsevFBMi_DzU_xuwo3LUja%3DxzRw%40mail.gmail.com
>>>>>>> <https://groups.google.com/d/msgid/django-users/CAKGT9myp4HU6%2BZo6d-JqeaTPsevFBMi_DzU_xuwo3LUja%3DxzRw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>>> .
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *TUYIZERE Eugene*
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Msc Degree in Mathematical Science*
>>>>>>
>>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
>>>>>> Garden-Lime, Cameroon*
>>>>>>
>>>>>> Bsc in Computer Science
>>>>>>
>>>>>> *UR-Nyagatare Campus*
>>>>>>
>>>>>> Email: eugene....@aims-cameroon.org
>>>>>> eugenet...@gmail.com
>>>>>>
>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *TUYIZERE Eugene*
>>>>>
>>>>>
>>>>>
>>>>> *Msc Degree in Mathematical Science*
>>>>>
>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
>>>>> Garden-Lime, Cameroon*
>>>>>
>>>>> Bsc in Computer Science
>>>>>
>>>>> *UR-Nyagatare Campus*
>>>>>
>>>>> Email: eugene....@aims-cameroon.org
>>>>> eugenet...@gmail.com
>>>>>
>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38
>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "Django users" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to django-users...@googlegroups.com.
>>>>> To view this discussion on the web visit
>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHtJhxd3-B%3DpzsAhqg_kR68zTvbJKd%2BgeBUqRjGMP%2BxgxQ%40mail.gmail.com
>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHtJhxd3-B%3DpzsAhqg_kR68zTvbJKd%2BgeBUqRjGMP%2BxgxQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Django users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to django-users...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/django-users/CAGp2JVGM87kRnp%2BZY_J8fKb2d_mU5Vvxv033oQSZ-ChHAeiFCA%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/django-users/CAGp2JVGM87kRnp%2BZY_J8fKb2d_mU5Vvxv033oQSZ-ChHAeiFCA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>
>>>
>>> --
>>> *TUYIZERE Eugene*
>>>
>>>
>>>
>>> *Msc Degree in Mathematical Science*
>>>
>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
>>> Garden-Lime, Cameroon*
>>>
>>> Bsc in Computer Science
>>>
>>> *UR-Nyagatare Campus*
>>>
>>> Email: eugene....@aims-cameroon.org
>>> eugenet...@gmail.com
>>>
>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Django users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to django-users...@googlegroups.com.
>>>
>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/85a1d671-d5c9-4f97-9f34-b6f1e1b36bcfn%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/85a1d671-d5c9-4f97-9f34-b6f1e1b36bcfn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
*TUYIZERE Eugene*
*Msc Degree in Mathematical Science*
*African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
Garden-Lime, Cameroon*
Bsc in Computer Science
*UR-Nyagatare Campus*
Email: eugene.tuyiz...@aims-cameroon.org
eugenetuyiz...@gmail.com
Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CABxpZHutfCZgBs6%2B0HtGsfyHtvs-wQi7sRf7SmGJagkFN0v8mw%40mail.gmail.com.
