My requirement is that i have an editable grid which has lets suppose 1000 rows and i have to only sent the updated one to Database.
i.e. if user change 3 out of 1000 rows then only 3 should be sent to process model or a!writerecords for updating this to DB rather than sending the whole 1000 rows. So what i did i created two variables for fetching record data from DB. 1 containing the original data and second containing the changed data, Now my requirement is to compare both these variables so that i can find the changed data which can then be sent for update.
Discussion posts and replies are publicly visible
Loading thousands of rows into an interface will not work. I suggest to check this page for examples on how to use grids.
https://docs.appian.com/suite/help/24.2/SAIL_Recipes.html
I have used pagination to tackle 1000 rows in one page. Now when i moved to next page so the previous changed values doesnt gets hold. Please suggest me how to hold all the changed rows in one variable.
Having 1000 editable rows in a single screen? But why? Why not create something in lesser batches with filters on it and enable the editable option.
Keeping it aside, you need to save your updated values in a local variable that does not refresh with the data that is being paged.
Basically i have applied pagination and was able to save the changed rows in one local var with the help of difference function. As soon as i move to next page, the value gets null, so how can i hold the value. Can you please help us with code,
You need to store only the updated rows of data in a variable which doesn't get refreshed during your paging.