I have a context node with some data, I do have another context node with different name and same attributes of 1st context node. The first context node holds data from UI, the second context node holds data from DB. I need to check these 2 and find out the new, changed and deleted records. I do have a unique identifier in both tables. I need to populate the new, changed and deleted in 3 different tables. New records or Changed records or Deleted records refers to Database.
New: If an entry from UI is new to Database
Changed: If an entry from UI and the same entry from Database has different attribute values.
Deleted: If an entry from Database is not found in UI. I mean the new set of Data in UI misses a few records from Database.
Please advice with your valuable thoughts