This discussion is archived
2 Replies Latest reply: Jun 3, 2013 12:12 PM by machan RSS

Interactive Report Search - escape ampersand (&)

machan Explorer
Currently Being Moderated
APEX 4.0.2

Example -
In IR if we search for 'AT&T' we don't get any results even if a few rows have AT&T.
Search for
'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 !!!
  • 1. Re: Interactive Report Search - escape ampersand (&)
    Martina1018 Newbie
    Currently Being Moderated
    Hi,

    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>
    Operator: contains
    Expression: <Your search expression with the ampersand> (without quotes)

    No need to escape any special character, APEX will automatically find rows that contain ampersands.
  • 2. Re: Interactive Report Search - escape ampersand (&)
    machan Explorer
    Currently Being Moderated
    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
    At&amp;t
    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 
    Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points