Oracle Apex Interactive report highlight row on the link click.

Oracle Apex: Highlight Row on Link Click of Interactive Report

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

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:

This Post Has 4 Comments

  1. MAHENDRA August 20, 2020

    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

    1. Vinish Kapoor August 20, 2020

      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.

    2. Ankita December 2, 2020

      Please can you tell this in brief? With example

  2. Ankita December 3, 2020

    Without clicking,when we search that time row should get highlighted in search result,what changes have to do for this criteria

Comments are closed.