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
Le lun. 12 sept. 2022 à 08:59, Muhammad Juwaini Abdul Rahman <
[email protected]> a écrit :
> You missed one quote ".
>
> On Mon, 12 Sept 2022 at 14:04, tech george <[email protected]> wrote:
>
>> 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
>> <https://groups.google.com/d/msgid/django-users/CADYG20G%3DgkpSgy9YnWaHFH%3DUsMOShZv%2BphidZ2EcuZkRfVjm3Q%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/CAFKhtoSDpEdvWfJtu6KrobRGP7o976qdKsmPxeSDdjE1Vgx8ag%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAFKhtoSDpEdvWfJtu6KrobRGP7o976qdKsmPxeSDdjE1Vgx8ag%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/CAB%2BG4bTXyxpa8DyMp23q2qVQVYZxk8Bz-zgvaa28_7tVHhLoiQ%40mail.gmail.com.
