This discussion is archived
2 Replies Latest reply: Nov 15, 2013 12:20 AM by fac586 RSS

Conditional Report Link Colour

Gus C Journeyer
Currently Being Moderated

Apex 4.2

 

I had an interactive report and part of the sql was a conditional link

 

 

case

  when exists (select 1 from udm_wh where ldeid = 1 and extkey = wh.mcd_gbldcno)

    then

'<a class="type" href="' || apex_util.prepare_url('f?p='||:APP_ID||':34:'||:APP_SESSION||'::'||:DEBUG||':34'||':P34_EXTKEY,P34_PG:'|| wh.mcd_gbldcno ||','|| 64, null, 'SESSION') || '"title="Go to Maintain DC for Global DC '|| wh.mcd_gbldcno ||'">' ||wh.mcd_gbldcno|| '</a>' -- link

  else to_char(wh.mcd_gbldcno) -- no_link

end mcd_gbldcno,

 

Inorder for this link to appear in blue, I used in my page header, inline css

.apexir_WORKSHEET_DATA td a.type:link,

.apexir_WORKSHEET_DATA td a.type:visited {

  color: blue;

  font-weight: bold;

}

 

I would like to chamge this to a standard report, but do not know how to format the link

 

Cheers

 

Gus

  • 1. Re: Conditional Report Link Colour
    fac586 Guru
    Currently Being Moderated

    GusC wrote:

     

    Apex 4.2

     

    I had an interactive report and part of the sql was a conditional link

     

     

    case

      when exists (select 1 from udm_wh where ldeid = 1 and extkey = wh.mcd_gbldcno)

        then

    '<a class="type" href="' || apex_util.prepare_url('f?p='||:APP_ID||':34:'||:APP_SESSION||'::'||:DEBUG||':34'||':P34_EXTKEY,P34_PG:'|| wh.mcd_gbldcno ||','|| 64, null, 'SESSION') || '"title="Go to Maintain DC for Global DC '|| wh.mcd_gbldcno ||'">' ||wh.mcd_gbldcno|| '</a>' -- link

      else to_char(wh.mcd_gbldcno) -- no_link

    end mcd_gbldcno,

     

    Inorder for this link to appear in blue, I used in my page header, inline css

    .apexir_WORKSHEET_DATA td a.type:link,

    .apexir_WORKSHEET_DATA td a.type:visited {

      color: blue;

      font-weight: bold;

    }

     

    I would like to chamge this to a standard report, but do not know how to format the link

    Either replace .apexir_WORKSHEET_DATA with the class of the standard report table (use a web inspector or view the template to find out what this is), or use an attribute selector to target the column:

     

    td[headers="COLUMN_ALIAS"] a.type:link,
    td[headers="COLUMN_ALIAS"] a.type:visited {
      color: blue;
      font-weight: bold;
    }
  • 2. Re: Conditional Report Link Colour
    Gus C Journeyer
    Currently Being Moderated

    Thank you

     

    Gus

Legend

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