How do I reset counters for process and case folder prefixes?
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?
Comments
-
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)
Howdy, Stranger!
Categories
- 4.2K All Categories
- 68 General
- 11 Training
- 204 Installation / Setup
- 1.1K Flows
- 108 Rules
- 265 Administration
- 212 Portal
- 495 General Q & A
- 703 Forms
- 335 Reports
- 3 Designer Extensions
- 47 Example Flows
- 55 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 181 Pages
- 5 Process Mining
- New Features
- 181 Datastructures
- 69 Repository
- 226 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 112 Lunch And Learn Questions