How do I reset counters for process and case folder prefixes?

[Deleted User]

I used to be able to reset counters for process folders prefixes by going to System > System Data > ID Generation, but I don't see the option there anymore. Has this changed?

[Deleted User]

In Decisions versions 6.19 onward, ID generation counters use SQL sequences, and these are now managed through SQL queries instead of the GUI.

You can use the below SQL queries for resetting these counters. (You'll need to restart the server to see these changes.)

Please note that it's important to backup your Decisions database before modifying it with SQL queries:

(Database backup documentation: https://documentation.decisions.com/docs/backup-of-decisions-database-and-file-system)

This query will return all sequences with their prefixes and status information:

SELECT *

FROM sys.sequences

To reset a specific sequence to 1, run the below query, replacing 'Prefix' with the prefix of the counter you'd like to reset:

ALTER SEQUENCE Prefix_sequence

RESTART WITH 1

To run these queries, right click on a designer folder, go to 'Other', and select the 'Query Editor'.

(Query Editor documentation: https://documentation.decisions.com/docs/query-editor)