[Bug]: Search and filter functions in the table widget do not work as expected when the column is formatted as HTML

Is there an existing issue for this?

• I have searched the existing issues

Description

When I change the Column Type of a table to HTML and then search (full table search) or filter (column contains 'my string') nothing is found. Workaround is to use a second column with Column Type Plain text and hide this column.

Seems like it's the same issue with URL 3 years ago: #23636

Sorting should take place by display text not computed value for the type column in the table.

Steps To Reproduce

1. Insert a table widget with random data (no HTML Code needed)
2. Change a column with text to HTML type
3. Search for one of the string or use the filters to find the text in that column

Public Sample App

No response

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

Self Hosted - 2.2 Enterprise