Workspace Dashboard - How to create filter on string column?

[VictorTheGeek]

I have created a Workspace for my custom application and my users are requesting a way to filter/update all elements on 1 dashboard based on changing a given column. For example, my table has a column called Business Name and the user wants to see all elements (data visualizations) update their data based on changing the business name. The key problem is that the column is a string. When editing the dashboard, users are able to add the Filter and/or Filter Group widget, but those don't allow string columns. 

[lauri457]

I believe your only option at least currently is to create the dashboard in ui builder instead of the inline editor. That way you can create a custom filter based on a string search.

I wouldn't hold my breath for the capability in inline editor as building string filters in legacy dashboards requires using the DashboardMessageHandler api to this day.

[Ankur Bawiskar · Accepted solution]

@VictorTheGeek 

filtering on String column is not supported in dashboards

You can have custom UI builder solution for this, this needs to be explored

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[VictorTheGeek]

I'll begrudgingly accept this as the answer. 😐😉
My "fix" will be to change as many columns as possible into Choice type. This won't work for all of our columns, but it'll give my users something to work with.