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!

Calculation in Integrated Grid

Bijaya Mantri33 hours ago — edited 32 hours ago

Hi Experts-

I have a requirement to calculate IG column values and when i try to get the input value it always shows old value

My calculation like

Cum Diff App -PO RD (Col C) = Approved ML SO RD ( col A) + Previous value of Cum Diff App -PO RD (Col C)

Approved ML SO RD ( col A) is editable, when i input value and enter, i see it always holds the old value although in UI it shows new value

Code: CONFIRM_AMOUNT is my column 1, i just checking here how to get the edited new value, the below piece of code gives old value, and when i again visisted same row, it shows new value

var i, i_quantity = 0, i_selids = "$",

model = this.data.model;

for ( i = 0; i < this.data.selectedRecords.length; i++ ) {

var i_value = parseInt((model.getValue( this.data.selectedRecords[i], "CONFIRM_AMOUNT" )).replace(/\,/g,''), 10);

if (isNaN(i_value)) {
var i_value = parseInt((model.getValue( this.data.selectedRecords[i], "CONFIRM_AMOUNT" )).replace(/\,/g,''), 10);
}

console.log("Row ID: " +  i  +   
           " | CONFIRM AMOUNT: " + i\_value);

}

Comments
Post Details
Added 33 hours ago
3 comments
60 views