Oracle Apex Interactive report highlight row on the link click.

Oracle Apex: Highlight Row on Link Click of Interactive Report

by

This Oracle Apex tutorial shows you how to highlight a row on the link click of the interactive report.

Oracle Apex version 19.1 is used to demonstrate this example.

1. Create a JavaScript function.

Add the following JavaScript code to the page having Interactive Report. Click on the Page then in the property palette, JavaScript > Function and Global Variable Declaration. Paste the following JavaScript function code in Function and Global Variable Declaration section:

function irRowhighLight( pThis ){
  $('td').removeClass('currentrow');
  $(pThis).parent().parent().children().addClass('currentrow') ;  
  var v_row = $(pThis).parent().next()();
}

2. Add the CSS to the page.

Click on the Page then in the property palette, CSS > Inline. Paste the following CSS code in the Inline section:

.currentrow
{ 
 background-color: #eeeeee !important;
}

3. Set Link Attribute for the Link.

Now select the column and set the type to Link. In the property palette, set the target for the link in the Link section and for the Link Attribute property, add the following code:

onclick=irRowhighLight(this);

It is done now. Save the changes and run the report to test. When you will click on the link the current row of the interactive report will be highlighted.

See also:

4 thoughts on “Oracle Apex: Highlight Row on Link Click of Interactive Report”

  1. Dear ,

    In Oracle Apex

    1) how to changed variable value in Processing, in Dynamic Action
    on button Click DataImport value is A
    on button Click Validate Data value is B
    means how to play with Variable

    2) How to set Classic Report Row Color on Condition.
    on invalid data, i want to show in RED color
    and on Valid data ...Green

    Thanks

    Reply

    • You can not access variables declared in any other program units like DA and processing.

      You can store variable values in some hidden items and then access them using the dynamic actions.

      To show the color for invalid data in classic report, you have to take an extra column in which you can flag if the particular column data is invalid. Then highlight it using the HTML and CSS. Soon will give an example on it.

Leave a Comment