Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
hello, I want to show sum of (qty from detail block) in total_qty in master block just like Oracle forms in Oracle apex but dynamic action is not supporting me in this regards as dynamic affected item is also from same block but I want to affect item from master block not from same (detail) block
what should I do ?
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.