Hello!
I have a question on default filtering behaviour in Apex Interactive reports with regards to columns which can contain multiple lines.
Situation is the following, we have an interactive report which displays data from a table where some columns are inputed through text area items.
In the report itself column type for these columns is set to "Plain Text" which apparently collapses new lines, so everything is displayed in one line, which is perfectly fine.
Problem arises when user wants to use default Apex filtering feature on these columns.
Users usually copy the value directly from report column and then paste it into the Apex filter input (see attached screenshots).
Interestingly, with values which originally don't contain new line characters this works fine, but with multi-line values it does not and no rows are matched.
I would guess something happens internally within Apex after filter is applied (removal of new line characters from filter string?), which results in the column value and filtering value not being the same anymore.
Apex version is 23.2.
Would appreciate any insight or possible solutions on this,
Thanks!
