New Retool user here.
I have the same issue with the new table component.
I have a mapped field that has a integer data value that is mapped to a table for the data display.
the filter action on that column only filters the value and not the display.
Thanks @Tess, this is one of those things that as we have our data system normalized actually impacts a lot of our workflow with the filtering. Let me know if this is something that plans on being addressed.
No update yet, unfortunately It is in our queue to be fixed, but it's hard to say what the timeline will be. I'll add this feedback to the internal ticket!
@Tess Just following up to see if there has been any traction. I can see that it has been a bug for a while. Any news or way to escalate this a little bit?
We use foreign keys in our tables that map to friendly text strings, often enough that I'm actually surprised that we hadn't noticed this before.
I was originally going to suggest adding a checkbox to the filter-setting widget like "use mapped value" or "use displayed value" but I think it's safe to assume the typical end user would expect the displayed value to be the default filtering value, because that's what they're seeing (they may not know, nor care, nor need to ever understand what the raw value is). Filtering on the raw value would actually be the exception.
Thanks for checking in. Unfortunately, we haven't been able to prioritize this over other requests. While we are tracking requests still, it doesn't appear to be on our near term roadmap