Hello, guys!
I need your help!
I have found that when an Interactive Grid is used in a modal page, scrolling does not work.
Here is what I mean:
1. I have an IG based on the query "SELECT col1, col2, col3 FROM table(table_function)"
2. IG Total Row = 172
3. My application has javascript code which selects rows from IG
var view$ = apex.region("P62_TAB_CONF").widget().interactiveGrid("getViews", "grid");
var model$ = apex.region("P62_TAB_CONF").widget().interactiveGrid("getViews", "grid").model;
var selectedRecord = view$.getSelectedRecords();
if(selectedRecord.length != 0){
model$.forEach(function(rec, idx, id){
for(i = 0; i < selectedRecord.length; i++){
if(id == selectedRecord[i][0] && model$.getValue(rec, "IS_SELECTED") !== 'Y'){
model$.setValue(rec, "IS_SELECTED", 'Y');
}
}
}
); //end ForEach
}
else
{
model$.forEach(function(rec, idx, id){
model$.setValue(rec, "IS_SELECTED", 'Y');
}
);
}
apex.submit("SUBMIT");
When I get to the modal page for the first time, I see Total Row = 172. When I start scrolling the IG, then the Total Row changes to zero. After that, I see 50 rows from 172, Total Row = 0 on the IG and when I try to save all or selected rows, my code does not work (because of Total Row = 0).
Maybe someone has already seen this?
How to solve this problem?
Thanks. =)