5 Replies Latest reply: Nov 21, 2012 3:41 AM by Jozef Demovic SVK RSS

    Conditional column link does not work

    robik
      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
          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
            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 Demovic SVK
              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
                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 Demovic SVK
                  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