How to change the value of a table column if one record is deleted
I have an employee table with columns empID, empname, company. I have created a section to intake empid and delete the corresponding record in the table DB. My empids run like 1,2,3 etc. If I delete empID 1 then the next record's empID value in the table should automatically become 1 and the record 3's empID should become 2 and so on. Is this possible? If yes, please tell me how.
Help is very much appreciated!!
***Edited by Moderator Marissa to move from Pega Academy to Pega Support Community; update platform capability tags***
Keep up to date on this post and subscribe to comments