This discussion is archived
5 Replies Latest reply: Nov 21, 2012 1:41 AM by jozef_SVK RSS

Conditional column link does not work

robik Newbie
Currently Being Moderated
Hi here is my conditional column link but I doesn't work.

Icon is shown but I can't click on it.

case when location_id = :F130_DEFAULT_LOCATION
then '<ahref="f?p=&APP_ID.:17:&SESSION.::NO::P17_RECORD_ID:'|| ccn_data.record_id || '">'
|| '<img src="#IMAGE_PREFIX#e2.gif">'
|| '' else NULL
end link_col,

Any suggestions?

Thanks

Robert
  • 1. Re: Conditional column link does not work
    GudrunPabst Newbie
    Currently Being Moderated
    Hi,

    the syntax for the link is not correct - you have to open the link with
    <a href=and close it (after the icon) with
    </a>

    Regards,
    Gudrun
  • 2. Re: Conditional column link does not work
    Jitendra Pro
    Currently Being Moderated
    Hi Robert,

    you missed closing of anchor tag
    case when location_id = :F130_DEFAULT_LOCATION then 
    '<a href="f?p=&APP_ID.:17:&SESSION.::NO::P17_RECORD_ID:'|| ccn_data.record_id || '">
    '|| '<img src="#IMAGE_PREFIX#e2.gif">'|| '</a>' else NULL
    end link_col, 
    
    //in place of # put 
    f?p=&APP_ID.:17:&SESSION.::NO::P17_RECORD_ID:'|| ccn_data.record_id ||'
    Regards,
    Jitendra
  • 3. Re: Conditional column link does not work
    jozef_SVK Journeyer
    Currently Being Moderated
    Hi,

    Are you use interactive report or standard report ?
    If yes. Why don't you use a image only + standard link column ? (i use it this way)
    case when location_id = :F130_DEFAULT_LOCATION then 
    '<img src="#IMAGE_PREFIX#e2.gif">' else NULL
    end link_col,
    ccn_data.record_id 
    To the column link attribute: #LINK_COL#
    Target: page 17
    Item / value: P17_RECORD_ID / #record_id#

    record_id you can select as hidden item in application.

    Regards
    J :D
  • 4. Re: Conditional column link does not work
    fac586 Guru
    Currently Being Moderated
    jozef_SVK wrote:
    Hi,

    Are you use interactive report or standard report ?
    If yes. Why don't you use a image only + standard link column ? (i use it this way)
    case when location_id = :F130_DEFAULT_LOCATION then 
    '<img src="#IMAGE_PREFIX#e2.gif">' else NULL
    end link_col,
    ccn_data.record_id 
    To the column link attribute: #LINK_COL#
    Target: page 17
    Item / value: P17_RECORD_ID / #record_id#
    Used in this way a standard link column will generate empty link elements that are confusing and irritating for those using keyboard navigation and users of assistive technology. Additionally, if the link is not being displayed for security reasons then this may be compromised by the ability to use keyboard navigation to activate empty links, or by the ability see values in the URLs of the empty links.

    In short, you shouldn't do this.
  • 5. Re: Conditional column link does not work
    jozef_SVK Journeyer
    Currently Being Moderated
    Hi,

    If the navigation is necessary in this case, then you shouldn't use it.
    (i normally use reports where users only clicking on some icon in some 100th row and not use the navigation like TAB, ...
    But it depend on the use case + proccesses in background)

    Regards
    J :D

Legend

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