case number

[blitz2190]

this mabe a simple procedure but how do i go about reseting the case number to 1

[andopes]

Take a look at this page.

Cheers

[salesagility]

Just curious ... why do you want to reset case numbers?

[blitz2190]

i was customizing the case module and needed to enter quite a bit of data. but when it came time to go live we didnt want it to start at a random high value once i cleared the database and thank andopes your suggestion worked

[Amy Sung]

We've tried the query in SQL. (Run a query: ALTER TABLE tablename AUTO_INCREMENT = 1)

of link posted from andopes. However it doesn't work.

Because there are many test cases in our CRM before. So we 'd like to reset the case no. to 1.

Is there any further solution?

Thank you!!

[leowolff]

Just clear the table direct on the database.

[Amy Sung]

Which table do you mean?
Cause after delete all the cases, the following case no. will not reset from no.1 automatically.

That's why we may need to do some edition from SQL.

Thanks for replying anyway.

Is there any solution?

[mapm]

Try to clean all tables and set to auto_increment on cases
accounts_cases
cases
cases_audit
cases_bugs

Or drop this tables and do a repair rebuild in admin

[Amy Sung]

Hi Mapm,
Thank you for the suggestions.

We've tried to cancel every records in Tables of SQL but the new no. still doesn't rest to no.1.

Is there anyone having more spicific directions?

thanks in advance!!

[ruchida]

Hi Mapm,
Thank you for the suggestions.

We've tried to cancel every records in Tables of SQL but the new no. still doesn't rest to no.1.

Is there anyone having more spicific directions?

thanks in advance!!

Hello,

You can not reset the an auto-increment number by simply deleting records. You need to run an alter table command. Try the following sql after you delete all of records.

 ALTER TABLE cases AUTO_INCREMENT = 1