[Bug]: Table with select column search and filter over the value, not over the label

[simonfvr]

Is there an existing issue for this?

• I have searched the existing issues

Description

When searching or filtering over a table with a select column type, those filters are applied using the value value of the select, but they should use the label value, i.e., what the user sees in the table.

Steps To Reproduce

1. Create a table widget.
2. Assign data, e.g., {{ [{ "column": "foo", }] }}.
3. Set column data type to select.
4. Set options for this table, e.g., {{ { "label":"bar", "value":"foo" } }}.
5. When searching or filtering bar, nothing appears. When searching or filtering foo, the row with the value bar appears.

Public Sample App

No response

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

Appsmith v1.38