Filter by date range

[tech george]

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

[carlos]

Hello why use raw?

query_results = Prescription.objects.filter(date__range=[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!

--
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/CADYG20Go5PXJRP-MGJ07M36ftSaQ6WJVjYg_p4UYB9UUWge-LA%40mail.gmail.com.

--

att.

Carlos Rocha

[tech george]

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__range=[fromdate,todate])

Regards,

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.

[Muhammad Juwaini Abdul Rahman]

What's your value of 'fromdate' and 'todate'?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADYG20F%3D3470-FCgJZ0amOHUDV%3DXvHQ6ZWKak2VjcB%2BjD26Qkg%40mail.gmail.com.

[tech george]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFKhtoTAKxT%2BLrQ-VqXzsV-7Rm1Z%2BeAwJkQXKRJYYkVZTemd4A%40mail.gmail.com.

[carlos]

hello try debug 

query_results = Prescription.objects.filter(date__range=["2022-07-01","2022-07-30"])

len(query_results)

if come with records so, fromdate and todate is the problem!

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADYG20Hkg9HB-ctFT004FJ1HtGunuXKXyBaWRMXuHcX5rNnBkg%40mail.gmail.com.

--

att.

Carlos Rocha

[Muhammad Juwaini Abdul Rahman]

Either there's no data for that month or your query is wrongly formatted. Probably you can try your query in the shell first.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADYG20Hkg9HB-ctFT004FJ1HtGunuXKXyBaWRMXuHcX5rNnBkg%40mail.gmail.com.

[tech george]

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?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFKhtoSuzW%2BEJt2DhinAJ1NxYHJpT6EW5Jdt4mxcKwyry4_ksw%40mail.gmail.com.

[tech george]

I managed to solve the issue.

I was using the wrong keyword to fetch the dates.

Thanks for the support.

[Muhammad Juwaini Abdul Rahman]

You missed one quote ".

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADYG20G%3DgkpSgy9YnWaHFH%3DUsMOShZv%2BphidZ2EcuZkRfVjm3Q%40mail.gmail.com.

[KPADE Kouami Antoine]

Hey friend

I think your problem is from

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_prescribed '

                                                 'between "'+str(fromdate)+'" and "'+str(todate)+'"')

please review the documentation

https://docs.djangoproject.com/en/4.1/topics/db/sql/

I hope I have answered your question

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFKhtoSDpEdvWfJtu6KrobRGP7o976qdKsmPxeSDdjE1Vgx8ag%40mail.gmail.com.