[Question] Multiple filters in DataTable

[ingdesarr1]

Question

Good morning. I want to apply multiple filters in a DataTable, but it doesn't work. I'm using the option visible to show the rows that apply to the filter, but if apply other filter, just show the last filter. How can I do that? Thanks

Code sample

def filter1():
    for data in value.controls[0].controls[0].rows[:]:
        date = datetime.strptime(data.cells[3].content.controls[0].value, '%d/%m/%Y')
        if date>=date_begin and date <=date_end:
            data.visible = True
            data.update()
        else:
            data.visible = False
            data.update()

def filter2():
    for data in value.controls[0].controls[0].rows[:]:
        if data.cells[4].content.controls[0].value != '-':
            date = datetime.strptime(data.cells[4].content.controls[0].value, '%d/%m/%Y')
            if date>=date_begin and date <=date_end:
                data.visible = True
                data.update()
            else:
                data.visible = False
                data.update()

Error message

No response

------------------------------------------------------

• I have searched for answers to my question both in the issues and in previous discussions.