Debug by printing val1 and val2 before filtering if those vslues are
dates(class) if true print expenses after filtering. Otherwise your date ranges
does not contain s data as required
On 20 Nov 2021, 10:49 +0300, Eugene TUYIZERE <eugenetuyiz...@gmail.com>, wrote:
> 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
> > > responseregards,
> > > --
> > > 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.
> > > 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.
> > --
> > 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.
>
>
> --
> 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.
--
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/114c19ce-a410-47d2-bd68-1c52d4f799c5%40Spark.
