- Goal: Table filtering is not working
- Steps: I use a single data source for a group of tables that are each associated to a tab. I attempt to create a specific set of filters for each table
Below is an image of one of the tables and the filter settings
The same data is also used for a different table and even though there is data that matches the filter criteria nothing is shown in the table
If I set the filter in the first table to filter on fd_ all of the proper data shows
Similarly if I remove the filter for fd_ and only filter on slates the full set of data shows in the table.
I ran the following in the console to show what javascript checks of the same filter shows for results
Not sure how the app is not showing the properly filtered data, there appears to be no logical reason for this happening. Any help would be greatly welcome
Hello @John_Male ,
I understand your issue. Here's a solution to address the table's tab filter and ensure the correct data is displayed in each tab:
- Use an SQL query with a
WHERE condition based on the current tab view.
- Set the query's run behavior to "automatic" so that it executes automatically whenever the tab changes.
Let me know if you need further assistance!
I appreciate the reply. I found that creating a new table with the same filter has the filter working properly. What I experienced here is probably more of a bug with the retool code than an issue related to having a filter in the SQL. Both the table filter and the filtering of the data should both work properly.
All of the other tabs are using a similar setup of components and none of the other tabs encounter this filtering issue. I have encountered a few different bugs that are similar with the retool product where javascript at the console level proves data exists and retool is not able to produce the same result
Closing since I have a solution by creating a new component
