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 <
juwa...@gmail.com> a écrit :
> You missed one quote ".
>
> On Mon, 12 Sept 2022 at 14:04, tech george <techgeor...@gmail.com> 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 <
>> juwa...@gmail.com> 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 <techgeor...@gmail.com>
>>> 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 <
>>>> juwa...@gmail.com> wrote:
>>>>
>>>>> What's your value of 'fromdate' and 'todate'?
>>>>>
>>>>> On Sat, 10 Sept 2022 at 13:27, tech george <techgeor...@gmail.com>
>>>>> 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 <crocha09...@gmail.com> 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 <techgeor...@gmail.com>
>>>>>>> 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 django-users+unsubscr...@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
>>>>>>>> <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 django-users+unsubscr...@googlegroups.com.
>>>>>>> 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 django-users+unsubscr...@googlegroups.com.
>>>>>> 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 django-users+unsubscr...@googlegroups.com.
>>>>> 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 django-users+unsubscr...@googlegroups.com.
>>>> 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 django-users+unsubscr...@googlegroups.com.
>>> 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 django-users+unsubscr...@googlegroups.com.
>> 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 django-users+unsubscr...@googlegroups.com.
> 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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAB%2BG4bTXyxpa8DyMp23q2qVQVYZxk8Bz-zgvaa28_7tVHhLoiQ%40mail.gmail.com.
