In IR if we search for 'AT&T' we don't get any results even if a few rows have AT&T.
, we'll get the results. Save with filters.
Is there any way we can escape special characters before adding the filter.
sys.htf.escape_sc this function would do that.
I tried to add it in DA by setting the value of apexir_SEARCH, but failed.
Please Suggest !!!
when I search my interactive report for let's say 'AG & CO', i just set the filter to:
Filter Type: Column
Column: <Name of your column>
Expression: <Your search expression with the ampersand> (without quotes)
No need to escape any special character, APEX will automatically find rows that contain ampersands.
I tried this in apex.oracle.com where the version is 4.2.2, and it works fine.
Also, I have this column as - Display as Text (escape special characters) here.
However, it doesn't work for me in 4.0.2.
If I change the IR column as - Display as Text (escape special characters), the value shows up as
Any application settings I need to change.
Both versions I am looking at have these values -
NLS_LANGUAGE - AMERICAN
NLS_TERRITORY - AMERICA
NLS_CHARACTERSET - AL32UTF8