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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to force Interactive Grid to load all rows to use with model.forEach(function(igrow)

Jake4321Jan 24 2022

Hi all,
I am currently working with APEX 19.1.
I am using an interactive grid to capture a series of RFP line items and I have this requirement were the user wishes have quantity * price computed to total_line_cost and in turn, the total_line_cost computed into a grand_total of all lines. And the users wishes to see both totals update dynamically when the price or quantity is changed.
Easy enough, I have this working like a clockwork, except when I have more than 50 lines. My understanding is that when updating, the data is not all loaded into the model at once. only chunks of 50 rows roughly. If I manually scroll down to the last line and click an item quantity or price then all gets computed perfectly even if I have more than 50 lines. I tried with RFP of 250 and more and it works perfectly.
Question: How can I get this to work without forcing the user to scroll down to the last line and click on the line? Is there a way to force reading all the data into the model?

Any tips, comments, suggestions are greatly appreciated as usual.

Thanks,
Jake

This post has been answered by Jake4321 on Jan 25 2022
Jump to Answer

Comments

InoL

Take a look in the IG Cookbook, page 5, Dynamic Column Total.

Jake4321
Answer

I can't find Page 5 but from other sources this cannot be done elegantly before version 20.1.
image.png
Thanks,
Jacque

Marked as Answer by Jake4321 · Jan 25 2022
1 - 2

Post Details

Added on Jan 24 2022
2 comments
1,317 views