Hello,
I’m encountering an issue with my Interactive Grid (IG) in Oracle APEX, specifically when trying to filter columns that contain formatted HTML. In my grid, I display data as “Display only” (Format → HTML), which works perfectly - the grid cells display the content correctly. However, the problem arises when I attempt to filter the column.
When I click on the column header, a list of distinct values is generated for filtering. These values are shown as plain text with raw HTML tags, rather than rendering the HTML formatting as it appears in the grid cells. I would like to see the formatted HTML in the filter values, just like the cells in the grid.
Writing a custom query for the filter list didn't help because the return and display values are identical. Additionally, it doesn't find rows with HTML tags when I remove them using a regexp_replace in my SELECT statement that builds the filter list.
Has anyone faced a similar issue or could share some guidance or sample code to help implement a custom filtering interface that displays formatted HTML? Any help or insights would be greatly appreciated!
Thanks in advance!