How do i reset case number back from 100000 to 100

💬 General Discussion
1

Hello,

I am new to suite crm and need help my boss changed the case number and we would like ti change it back but now stated it needs to be higher then what he changed it too any way we can revert the case number to its original state. ex. he changed it too 100000000 and we would like it to start at 100.

I would like to see how i can change this to a lower number, any way this can be done?

Thank you in advance

2

case_number field in the cases Table is an auto increment number. You can reset that via DB to any starting number you like. Make sure there are no duplicate numbers moving forward. You can update it via query too.


ALTER TABLE `cases` AUTO_INCREMENT = 100;