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.
