Skip to main content
N
niharikan2636
July 22, 2024
Question

How to compare two record variables of same type

  • July 22, 2024
  • 5 replies
  • 0 views

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
    stefanhelzle0001
    Brainy
    July 22, 2024

    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

    N
    niharikan2636Author
    July 24, 2024

    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
    konduruc733182
    July 24, 2024

    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.

    Terms & ConditionsAccessibility statement