Skip to Main Content

Visual Builder

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.

Table with Buffering Data Provider bugs out on updateItem after pagination triggers.

Luca CampelliFeb 26 2025 — edited Feb 27 2025

In Visual Builder Studio,

I have followed the blueprint for an Editable Table with Buffering data provider.

I have a table with a BDP as data provider, the BDP is attached to an SDP with custom fetch workflow, pagination is set to default (25 records at a time up to 500).

Load the data and after the table paginates by scrolling down to the limit of the table, editing an item in the pagination zone (after item number 25) freezes the application. Network tab shows infinite loop of queries to the specific record.

OnBeforeRowEdit chain is as simple as possible:

if(!cancelEdit){
const updateItem = await $page.variables.ValuesBDP.instance.updateItem({
metadata: {
key: rowKey,
},
data: changedRow,
});
}
$variables.Edit = false;

So issue is within BDP's updateItem's code, interacting with the SDP after pagination.

The only way I found for this to work is to set the limit in my custom fetch action to 500, so this way it does not paginate.

I understand it's not really best usability practices to have the user scroll through so many records. I have added further options for the user to further filter the data. Still, 50 to 100 records is a reasonable amount to show the user, and if the table paginates, the application breaks when attempting to edit a record in the range of pagination.

I can provide any necessary information to help understand if this may be an issue with my code or if this is really an issue with the component, how can I initiate a bug report to Oracle?

Thanks

Comments

Post Details