CA Service Desk Manager
________________________________________________________________________
Hello, I'd like somebody help me with this...
I need register in "zLog_Values" table every change made in some fields of "zValues" table, using spel code
I have two custom tables: "zLog_Values" and "zValues".
The "zValues" fields are:
-cr_persid (SREL to cr table)
-chg_persid (SREL to chg table)
-value1
-value2
-value3
I need register in "zLog_Values" table the following values from zValues table and the current session:
-Contact name who is making the change in the field (connected user)
-Modification date (current date)
-Current value (fields= value1, value2, value3)
-New value entered by the user(fields= value1, value2, value3)
-Request/Incident/Problem/Change persid
Thanks in advance,
Ana KBS.