Filter Table on all columns at once

App Building
1

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!

2

Hello, i achieved something similar like this:

image
image1116×446 30.9 KB

image

1 Like
3

With filter component
image

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

will show rows where any of the 3 filters is true

3 Likes
4

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

3 Likes