Suppose you want to derive the Amount total in the Interactive Grid to the P99_TOTAL Field in another region may be. You may need to go through the following instructions:
AMOUNT = Interactive Grid Column.
:P99_TOTAL = Sum/Total in the page Item.
Instructions :-
1 - Static ID - tots
2 - Find and replace if necessary "AMOUNT" and P99_TOTAL in the below code.
3 - Now copy and paste the below jquery code to Function and Global Variable Declaration (copy and paste)
// create a private scope where $ is set to apex.jQuery
(function($) {
// This is the function that calculates over all the rows of the model and then
// updates something else.
// Change this to do whatever calculation is needed.
// Call this whenever the model data changes.
function update(model) {
var salKey = model.getFieldKey("AMOUNT"),
total = 0;
console.log(">> starting sum AMOUNT 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;
}
});
console.log(">> setting sum SAL column to " + total)
$s("P99_TOTAL", total);
}
//
// This is the general pattern for subscribing to model notifications
//
// need to do this here rather than in Execute when Page Loads so that the handler
// is setup BEFORE the IG is initialized otherwise miss the first model created event
$(function() {
// the model gets released and created at various times such as when the report changes
// listen for model created events so that we can subscribe to model notifications
$("#tots").on("interactivegridviewmodelcreate", function(event, ui) {
var sid,
model = ui.model;
// note this is only done for the grid veiw. It could be done for
// other views if desired. The imporant thing to realize is that each
// view has its own model
if ( ui.viewId === "grid" ) {
sid = model.subscribe( {
onChange: function(type, change) {
console.log(">> model changed ", type, change);
if ( type === "set" ) {
// don't bother to recalculate if other columns change
if (change.field === "AMOUNT" ) {
update( model );
}
} else if (type !== "move" && type !== "metaChange") {
// any other change except for move and metaChange affect the calculation
update( model );
}
},
progressView: $("#P99_TOTAL") // this will cause a spinner on this field (P99_TOTAL is page Item: We can change it)
} );
// if not lazy loaded there is no notification for initial data so update
update( model );
// just in case fetch all the data. Model notifications will
// cause calls to update so nothing to do in the callback function.
// can remove if data will always be less than 50 records
model.fetchAll(function() {});
}
});
});
})(apex.jQuery);
Enjoy!
