Hi Greg,

What I understood so far, that you are expanding and collapsing the region using the buttons by manually clicking on it, but you want it to happen using the JavaScript or jQuery, and buttons should also not visible.

You can try this:

Specify a static id for the buttons and create a dynamic action for page-load to hide them using the $x_Hide() method. Below is an example:

$x_Hide('btnExpand');

Now your button with static id “btnExpand” will be hidden.

You can create then a dynamic action to execute JavaScript code to click this button using the following JS code:

document.getElementById('btnExpand').click();

Whatever the code is written (using the DA) on click event for the button “btnExpand” will be executed.

Please let me know if it solves the purpose. Thanks.

To display the sum of the quantity field using JavaScript, you can create a dynamic action on the interactive grid for Save event or lost focus event for the quantity column to execute JavaScript code. First, specify a static id to the grid, for example, “billing” now use the below JavaScript code. Modify it as per your table columns:

var model = apex.region("billing").widget().interactiveGrid("getViews", "grid").model;
var n_qty, n_totqty = 0;
col_qty = model.getFieldKey("QTY");
model.forEach(function(igrow) {
n_qty = parseInt(igrow[col_qty], 10);
if (!isNaN(n_qty)) {
n_totqty += n_qty;
}
});
$s('P2_TOTALQTY', n_totqty);

Set the affected items accordingly. For more details, check the following tutorial: Loop Through Interactive Grid in Oracle Apex.

Hi Celinehy,

To do this, you need an SQL Update statement something like below:

Update YourBookingTable
    set status = 'REJECTED'
where EID = 'E001' and BOOKID != '0006';

Instead of hard-code ‘0006’, you can use your Apex page item and do the same for equipment ID.

Now, if there is not only booking id ‘0007’ but if any other booking id exists, that will also get rejected. You can also use a date field (PICKUP_DATE) to run the Update statement for a day, that is up to your requirement.

Please let me know if any doubts. Thanks.

It depends on the requirement, like the above question, the from clause query is the appropriate solution for this.

So if any time, you think that your purpose is not going to solve by simply specifying one or more tables for a data block, then you can use the from clause query feature. This is the only benefit of this.

Yes, this selects only the records currently visible in the interactive grid.

You can create a dynamic action on the interactive grid on the Page Change or View Change event to execute the same JavaScript code again.

Or, if you know the maximum records that the grid is going to contain, for example, 100 records, then you can change the heading section to Fixed to Region and specify the region height in pixels, for example, 500 in the attribute section of the grid.