Good Morning! As in pic I have interactive grid with values and type (Debit or Credit) and a dynamic action javascript code that calculate sum of both types the problem is when the user choose to delete a row like the pic , I don't know how to get that status to remove the value of this row from the calculation...
I have tried to use apex.item("APEX$ROW_STATUS") but it's not giving me any value anyone can point me to the right direction please....
thanks in advance
Have a look at the "Interactive Grid cookbook v6" mentioned in this blog. Page 5 has an example of a page item that is updated on change of an interactive grid. In the implementation you can see how deleted rows are handled:
function update(model) {
var salKey = model.getFieldKey("SAL"),
total = 0;
console.log(">> starting sum SAL column")
model.forEach(function(record, index, id) {
var sal = parseFloat(record[salKey]), // record[salKey] should be a little faster than using model.getValue in a loop
meta = model.getRecordMetadata(id);
if (!isNaN(sal) && !meta.deleted && !meta.agg) {
total += sal;
}
});
$s("P5_TOTAL", total);
}
The RecordMetadata of a row has a property "deleted" that you can check for the status of a row.