如何从当前Djangofi导出csv数据

Question

如何从django filterset导出CSV当前数据

视图.pydjango过滤器

def fourm(request):
    data_list = FourmAproveCoWeb.objects.all()
    data_filter = DataFilter2(request.GET, queryset=data_list)
    return render(request, 'fourmlist.html', {'filter': data_filter})

过滤器.py

class DataFilter2(django_filters.FilterSet):
    issue_date = django_filters.DateFromToRangeFilter()
    qa_follow_up_date = django_filters.DateFromToRangeFilter()
    class Meta:
        model = FourmAproveCoWeb
        fields = ['issue_date','pic_field','status','ecr','number_4m','qa_follow_up_date']

@视图导出功能

我想导出到数据过滤器已经。它不起作用

def export_as_csv(request):
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="somefilename.csv"'
    data_list = FourmAproveCoWeb.objects.all()
    data_filter = DataFilter2(request.GET, queryset=data_list)
    writer = csv.writer(response)
    writer.writerow(['PIC','Process']) 
    x = []
    for i in data_filter.qs:
        print(i.ecr)
        writer.writerow([i.pic_field,i.process]) 
    return response