Search bar text input messes up drop down filters.

Hi,

I have a database displayed in a table and you can search the table through drop downs or through a text input search bar. Both give the result when searched, but when I clear the text input the table doesn’t reset to the complete list, some filter gets stuck I imagine. When after clearing the text input and then I want to filter through a drop down the table get not filtered.
Also I’m trying to display the amount of rows each time when filtered but the amount runs one filter behind.

This is the overview of the table:


Filtered on a drop down:

So far, so good.

Filtered on a text input search:


The results are given but the count stays 449 instead of 2 in this example.

Then I clear the text input and the table loads again but not all original rows are shown:


Next I try to filter through a drop down menu but the filter is not applied on the table:

This is the code I used: