Displaying 400 rows of records on web for Editing

HCL Domino Domino Forum
1

Guys, Need yr suggestion on how to achieve this.

I need to display dynamically a list of 400-500 records from a Db2 table in web and have the user edit each row and save it back to the Db2 table.

I can retrieve the records on load, but

  1. how do i efficiently display that many records on web for editing. Hard coding is not possible.

  2. The records has to be displayed in a table with each row showing 4 fields (like Current price, Current discount, New price, New discount).

  3. I need the user to be able to edit the 4 fields on each row and then save the changes back to the Db2 table.

Have you done a similar functionality in your web applications ? Please advice. We are on 8.5.1

2

Subject: ext-js

i typically use ext-js with ajax/json response for something like this. You can have a paging toolbar handle the page chunks nicely.

3

Subject: Thx

Thanks Timothy and Erik

4

Subject: Should be fairly straightforward with an XPage.

You’ll probably want to use Java in the SSJS to connect to the db and read/write the changes back.

5

Subject: Thx

Thanks Erik. But i am new to this version and have little knowledge about XPages. Can you give me more insight/details or please direct me in the correct direction.