Skip to main content
Known Participant
Jul 22, 2024 11:35 AM UTC
Question

How to compare two record variables of same type

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.

    5 replies

    stefanhelzle0001
    Brainy
    Jul 22, 2024 2:40 PM UTC

    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

    Known Participant
    Jul 24, 2024 1:00 PM UTC

    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.

    konduruc733182
    Inspiring
    Jul 24, 2024 2:24 PM UTC

    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.