ResetCaseCounter

From PikaDocs

On January 1st of every year, most programs will want to reset their Pika case counters. After the counter is reset, the next new case will be numbered XXXX00001. The procedure is as follows:

  • Log into phpMyAdmin (or which ever software you use to administrate

your Pika database.)

  • Select your Pika database from the menu of databases on the server.
  • Click on the tab labeled "SQL".
  • Paste the following SQL code into the form:

UPDATE counters SET count='0' WHERE id='case_number' LIMIT 1;

  • Click the "Go" button.

That's it!

-Aaron

Retrieved from "http://pikasoftware.com/docs/index.php/ResetCaseCounter"