Filter Table on all columns at once

Hi, I am using a table to display some data. Now I want to quickly search/filter based on several/all columns at once.

For example: I have columns like name, familyname, birthname, etc. And I want to find rows where SEARCHQUERY is in any of those fields.

I can not resend the query to my API since it doesnt support a useful WHERE condition

I looked at the filter component Filter | Retool Component Library but it seems I cannot configure it in any way that would help me with this use case.

Any ideas are appreciated!

Hello, i achieved something similar like this:


1 Like

With filter component

If role is Admin OR teams includes Design OR enabled is false

will show rows where any of the 3 filters is true


@Oscar_Ortega brilliant! thanks! that exactly was what I was looking for.