How To identify old and new value of a column in a same row while using GridDB


Is there any script to identify the OLD and NEW value of a column (last updated), output need in a single row with two different columns with OLD_Value and New_Value like this?

I am using GridDB on the Windows platform.

Best Answer

Answered by mustaccio in a comment:

This can only be done while the row is being updated, in a trigger.