Add filter to Interactive Table if data source is a variable

An Interactive Table based on a Tulip Table has a filter option:

Pic of settings

But if the data source is a variable, there is no filter option:

Pic of settings

Can the filter option become available on variable-based Interactive Tables?

I liked the idea in this post, but I can’t implement it.

1 Like

Hi Jason-
Thanks for the feedback, we agree that it would be very useful to have filters on both types of tables. It is something we would like to add, but it is not likely to be right away unfortunately.

1 Like

Hi @JasonMcD,

Is your variable sourced from a SQL connector function? If so, a potential workaround could be implementing your query with some filter options as well (the only downside here is you would need to re-execute the query to search vs. the dynamic filtering that embedded tables have). You should only need one query and just use a WHERE and SIMILAR TO SQL statement so it works with or with out the filter!

Let me know how this works for you!

Thanks,
Grant

You should use a query table to filter on app variable.
You can add as much variables you want. You just need to use “any” as conditionning

@Grant Sorry I didn’t see this earlier. I thought this would send an email, but that’s another topic…

The variable is HTTP (REST), not SQL. But I get your idea, that I could use inputs and parameters.

Exactly. A relatively small amount of data can still be huge list to scroll through. So active filtering would be great.

To do this with constant API calls, it can take a few seconds for the round trip, which adds up if you aren’t a robot who goes directly to the data it needs, but rather you poke around a bit till you get the right job number or whatever.

1 Like