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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> >>> 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 <[email protected]> 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: [email protected] >>>>> [email protected] >>>>> >>>>> 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 [email protected]. >>>>> 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 [email protected]. >>>> 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: [email protected] >>> [email protected] >>> >>> 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: [email protected] >> [email protected] >> >> 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 [email protected]. >> 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 [email protected]. > 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: [email protected] [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com.
