How to get previous and next row data in an Interactive grid

josjos

Hello,

I'm using apex 21.2

I get the ID from first and last record like this:

var grid = apex.region('MY_INTERACTVE_GRID').call('getCurrentView'),
    model = grid.model,
    totalRecords = model.getTotalRecords(),
    firstRecord = model.recordAt(1),
    lastRecord = model.recordAt(totalRecords  - 1);

console.log(firstRecord[1]);
console.log(lastRecord[1]);

I also can get the selected id record ...

var model = this.data.model;
if (this.data != null){
  if(this.data.selectedRecords[0] != null){
    v_curr_id = model.getValue(this.data.selectedRecords[0], "ID");
  }
}
apex.item("P1_SELECTED_ID").setValue(v_curr_id);

but how do I get the ID from the previous and next row ?

Hamza Al-abbasi

Hello josjos,

but how do I get the ID from the previous and next row ?

You mean the Next/Previous record ID of selected row ? if it is try this :

var region$ = apex.region("[IG_STATIC_ID]").widget(),
    currentRow$ = region$.find(".a-GV-row.is-selected"),
    prevRowID = currentRow$.prev().data("id"),
    nextRowID = currentRow$.next().data("id");

console.log("Previous Row ID = " + prevRowID);
console.log("Next Row ID = " + nextRowID);

Hamza Al-abbasi

https://community.oracle.com/tech/developers/discussion/comment/16849148#Comment_16849148

var region$ = apex.region("[IG_STATIC_ID]"),
    widget$ = region$.widget(),
    model = region$.call("getCurrentView").model,
    currentRow$ = widget$.find(".a-GV-row.is-selected"),
    prevRowID = currentRow$.prev().data("id"),
    nextRowID = currentRow$.next().data("id");

console.log("Previous Row ID = " + model.getRecordValue(prevRowID, "P_ID");
console.log("Next Row ID = " + model.getRecordValue(nextRowID, "P_ID");

Hamza Al-abbasi

Hello josjos,

but how do I get the ID from the previous and next row ?

You mean the Next/Previous record ID of selected row ? if it is try this :

var region$ = apex.region("[IG_STATIC_ID]").widget(),
    currentRow$ = region$.find(".a-GV-row.is-selected"),
    prevRowID = currentRow$.prev().data("id"),
    nextRowID = currentRow$.next().data("id");

console.log("Previous Row ID = " + prevRowID);
console.log("Next Row ID = " + nextRowID);

josjos

https://community.oracle.com/tech/developers/discussion/comment/16849037#Comment_16849037

Hello, @Hamza Al-abbasi,

This method works but it gets the primary key which is the ROWID column.

How can I get a specific column value from the row? Lets say I have NAME column, P_ID column and ROWID hidden column. How do I get the P_IDs of the  Next/Previous record of selected row ?

Hamza Al-abbasi

https://community.oracle.com/tech/developers/discussion/comment/16849148#Comment_16849148

var region$ = apex.region("[IG_STATIC_ID]"),
    widget$ = region$.widget(),
    model = region$.call("getCurrentView").model,
    currentRow$ = widget$.find(".a-GV-row.is-selected"),
    prevRowID = currentRow$.prev().data("id"),
    nextRowID = currentRow$.next().data("id");

console.log("Previous Row ID = " + model.getRecordValue(prevRowID, "P_ID");
console.log("Next Row ID = " + model.getRecordValue(nextRowID, "P_ID");

josjos

https://community.oracle.com/tech/developers/discussion/comment/16849152#Comment_16849152

Thank you. Works like a charm!