Hello, I have tried debugging as below and it returned data;
search_results = Prescription.objects.filter(date_prescribed__range=["2022-07-01",2022-07-30"]) Is there another way i can filter the dates? On Sun, Sep 11, 2022 at 9:47 AM Muhammad Juwaini Abdul Rahman < [email protected]> wrote: > Either there's no data for that month or your query is wrongly formatted. > Probably you can try your query in the shell first. > > On Sun, 11 Sept 2022 at 02:12, tech george <[email protected]> wrote: > >> Hello Muhammad, >> >> I'm choosing dates between 2022-07-01 and 2022-07-30 which have records >> in the db. >> >> I hope i have answered you right. >> >> >> On Sat, Sep 10, 2022 at 8:41 AM Muhammad Juwaini Abdul Rahman < >> [email protected]> wrote: >> >>> What's your value of 'fromdate' and 'todate'? >>> >>> On Sat, 10 Sept 2022 at 13:27, tech george <[email protected]> >>> wrote: >>> >>>> Hello Carlos, >>>> >>>> I have used the code below as you advised by when I filter the table >>>> comes blank: >>>> >>>> query_results = Prescription.objects.filter(date__rang >>>> e=[fromdate,todate]) >>>> >>>> Regards, >>>> >>>> >>>> On Fri, Sep 9, 2022 at 6:11 PM carlos <[email protected]> wrote: >>>> >>>>> Hello why use raw? >>>>> query_results = Prescription.objects.filter(date__rang >>>>> e=[fromdate,todate]) >>>>> if you have any problem with performance hit database use >>>>> select_related or used m2m field use prefect_related >>>>> https://docs.djangoproject.com/en/4.1/ref/models/querysets/ >>>>> >>>>> best! >>>>> >>>>> On Fri, Sep 9, 2022 at 7:48 AM tech george <[email protected]> >>>>> wrote: >>>>> >>>>>> Hello friends! >>>>>> >>>>>> I am trying to give users an easier way to filter data by date range. >>>>>> >>>>>> My views.py code is as below, but unfortunately, it is hiding data >>>>>> without applying the filter whenever I try to use if, else statements. >>>>>> >>>>>> Please advise what I might be doing wrong. >>>>>> >>>>>> views.py >>>>>> >>>>>> ef referralsReports(request): >>>>>> if request.method=="POST": >>>>>> fromdate = request.POST.get('fromdate') >>>>>> todate = request.POST.get('todate') >>>>>> searchresults = Prescription.objects.raw('select >>>>>> id,description,prescribe,ailment,ailment_2,ailment_3,' >>>>>> >>>>>> 'sickOff,referral,date_precribed,nurse_id,patient_id_id,' >>>>>> >>>>>> 'non_work_related_sickOff from pharmacy_prescription where >>>>>> date_precribed ' >>>>>> 'between >>>>>> "'+str(fromdate)+'" and "'+str(todate)+'"') >>>>>> return render(request, >>>>>> 'pharmacist_templates/reports/referrals_report.html', {"data": >>>>>> searchresults}) >>>>>> >>>>>> else: >>>>>> displaydata = >>>>>> Prescription.objects.filter(nurse=request.user.pharmacist).order_by('-id') >>>>>> return render(request, >>>>>> 'pharmacist_templates/reports/referrals_report.html', >>>>>> {"data":displaydata}) >>>>>> >>>>>> >>>>>> template >>>>>> >>>>>> [image: image.png] >>>>>> >>>>>> >>>>>> -- >>>>>> 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/CADYG20Go5PXJRP-MGJ07M36ftSaQ6WJVjYg_p4UYB9UUWge-LA%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/django-users/CADYG20Go5PXJRP-MGJ07M36ftSaQ6WJVjYg_p4UYB9UUWge-LA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> >>>>> >>>>> -- >>>>> att. >>>>> Carlos Rocha >>>>> >>>>> -- >>>>> 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/CAM-7rO3UTB%2Bm7gYzfQ_RB%2BDnDWetnO3E18knFuLPJAU%2BBQrbLw%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/django-users/CAM-7rO3UTB%2Bm7gYzfQ_RB%2BDnDWetnO3E18knFuLPJAU%2BBQrbLw%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/CADYG20F%3D3470-FCgJZ0amOHUDV%3DXvHQ6ZWKak2VjcB%2BjD26Qkg%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/django-users/CADYG20F%3D3470-FCgJZ0amOHUDV%3DXvHQ6ZWKak2VjcB%2BjD26Qkg%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/CAFKhtoTAKxT%2BLrQ-VqXzsV-7Rm1Z%2BeAwJkQXKRJYYkVZTemd4A%40mail.gmail.com >>> <https://groups.google.com/d/msgid/django-users/CAFKhtoTAKxT%2BLrQ-VqXzsV-7Rm1Z%2BeAwJkQXKRJYYkVZTemd4A%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/CADYG20Hkg9HB-ctFT004FJ1HtGunuXKXyBaWRMXuHcX5rNnBkg%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CADYG20Hkg9HB-ctFT004FJ1HtGunuXKXyBaWRMXuHcX5rNnBkg%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/CAFKhtoSuzW%2BEJt2DhinAJ1NxYHJpT6EW5Jdt4mxcKwyry4_ksw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAFKhtoSuzW%2BEJt2DhinAJ1NxYHJpT6EW5Jdt4mxcKwyry4_ksw%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/CADYG20G%3DgkpSgy9YnWaHFH%3DUsMOShZv%2BphidZ2EcuZkRfVjm3Q%40mail.gmail.com.
