Dear Ramadhan,
Still it does not work
On Sat, 20 Nov 2021 at 09:18, ramadhan ngallen <ngall...@gmail.com> wrote:
> Depends on your query filter_val2 should lower than filter_val1 as the
> range start from val2 to val1.
> Otherwise change your parameter from val1 to val2
> EXPENSES.objects.filter(Q(created_at__range=[filter_val2,filter_val1]))
>
> On 20 Nov 2021, 10:04 +0300, Eugene TUYIZERE <eugenetuyiz...@gmail.com>,
> wrote:
>
> Dear Team,
>
> I am trying to export filtered data from a django model, but I get an
> empty file. But when I remove the filter and add all, it works.
>
> Kindly assist to know how to export filtered data. Below is my code
>
> def exportexpenes(request):filter_val1=request.POST.get("filter1")
> filter_val2=request.POST.get("filter2")response=HttpResponse(content_type=
> 'text/csv')response['Content-Disposition'] = 'attachment;
> filename=expenses' + str(datetime.datetime.now())+'.csv'writer = csv.
> writer(response)writer.writerow(['Category','Beneficiary','Description','Operation
> Date','Amount','Account Number','Paymrnt Date','Status'])expes = EXPENSES.
> objects.filter(Q(created_at__range=[filter_val2,filter_val1]))# expes =
> EXPENSES.objects.all()for exp in expes:writer.writerow([exp.category,exp
> .beneficiary,exp.description,exp.date_of_operation,exp.amount,exp
> .account_number,exp.payment_date,exp.status])return response
> regards,
> --
> *Eugene*
>
> --
> 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
> <https://mailto:django-users+unsubscr...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CABxpZHuqV0Py%3D05eyu%3Dv%3DDFBm%2B1y9v-e2AbmVn2Bvj66jG8MZA%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CABxpZHuqV0Py%3D05eyu%3Dv%3DDFBm%2B1y9v-e2AbmVn2Bvj66jG8MZA%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/93a559c8-bc77-44b7-8499-469db0f224e5%40Spark
> <https://groups.google.com/d/msgid/django-users/93a559c8-bc77-44b7-8499-469db0f224e5%40Spark?utm_medium=email&utm_source=footer>
> .
>
--
*TUYIZERE Eugene*
*Msc Degree in Mathematical Science*
*African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
Garden-Lime, Cameroon*
Bsc in Computer Science
*UR-Nyagatare Campus*
Email: eugene.tuyiz...@aims-cameroon.org
eugenetuyiz...@gmail.com
Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38
--
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/CABxpZHvFzd3N1ur5%3DbzmDtJUUAF3BfjamMg7pra-RCL5ffjZCw%40mail.gmail.com.
