How to filter exported data by a value on database using django export import

I want to export a student data from my database and filter it by roles column.

Views.py

def export_siswa(request):
    user = userResource()
    dataset = user.export()
    response = HttpResponse(dataset.xls, content_type='application/vnd.ms-excel')
    response['Content-Disposition'] = 'attachment; filename=Data_Siswa.xls'
    return response

resource.py

class userResource(resources.ModelResource):
    username = Field(attribute='username', column_name='Username')
    namadepan = Field(attribute='namadepan', column_name='Nama depan')
    namabelakang = Field(attribute='namabelakang',column_name='Nama belakang')
    email = Field(attribute='email',column_name='Email')
    jeniskelamin = Field(attribute='jeniskelamin',column_name='Jenis kelamin')
    tanggallahir = Field(attribute='tanggallahir',column_name='Tanggal lahir')
    agama = Field(attribute='agama',column_name='Agama')
    alamat = Field(attribute='alamat',column_name='Alamat')
    telepon = Field(attribute='telepon',column_name='Telepon')

    class Meta:
        model = modelUser
        fields = ['username','namadepan','namabelakang','email','jeniskelamin','tanggallahir','agama','alamat','telepon','role']
        export_order = ['username','namadepan','namabelakang','email','jeniskelamin','tanggallahir','agama','alamat','telepon','role']

That is my code for the views and resource.py .. but they show all of the data .. i want the exported data is a student with "student" roles

Back to Top