• Post author:
  • Post category:Apex
  • Reading time:2 mins read
Oracle Apex Interactive report highlight row on the link click.

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

Advertisement

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:

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

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.

Advertisement

See also:

Related:  Import CSV File Using New Oracle Apex 19.1 Data Loading Feature

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.

This Post Has 4 Comments

  1. MAHENDRA

    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

      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

      Please can you tell this in brief? With example

  2. Ankita

    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.