Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to make a LOV clickable with Interactive Grid (IG)?

Juliano PanMay 6 2024 — edited May 6 2024

I needed to develop a POPUP LOV with some specific filters, I tried using SmartFilters but I couldn't find a template that had a grid and columns. Therefore, I used an Interactive Grid.
I will describe the steps below:

1. I created a button to call my popup lov:

I created a DA to return the selected value at the LOV to my current page:

2. In the Interactive Grid I created the DA Selection Change [Interactive Grid] with 2 actions:

let view = apex.region("regProc").call("getCurrentView");
rec = view.getContextRecord( document.activeElement);
id = (rec.length == 1 ? rec[0][0] : null);
apex.item( "P12_ID_SOLICITACAO" ).setValue(id);

Dont forget to put the affected element at the JavaScript action:

At the Close Action I put a Client-side Condition:

3. I also added CSS at the page to make my LOV prettier:

.a-GV-table tr:hover td{
   background-color:#FCBABF;
   cursor:pointer;    
}

That's the final result:

I hope I helped anyone who had the same issue. ;)

Comments
Post Details
Added on May 6 2024
0 comments
400 views