How can I change the SQL sequence value for a Case Entity within Decisions?

charlesjohnson

I have a Case Entity whose sequence is currently at 700. I would like the sequence to start at another value. How can I achieve this?

Cody_Decisions

Hi there,

To set a new sequence value for a case entity we first need to confirm the Case ID Prefix found within the CaseDataStructure. This can be found by right-clicking the CaseDataStructure and selecting “Edit Defined Data Structure”.

Upon doing so, you can view the Case ID Prefix under CASE SETUP.

This value will determine the sequence we need to change within MSSQL. Take note of this value.

You can view a list of all sequences used in your instance by running the following query within your SQL database or within the Query Editor. The Query Editor can be found by right-clicking any Designer Project Folder and selection Other > Query Editor.

--Query to list all sequences used in your instance

SELECT * FROM sys.sequences

The case entity sequence will be held in the sequence object x_sequence, where the value "x" is your Case ID Prefix mentioned previously. For example, if your Case ID Prefix was "G", the associated sequence object would be "g_sequence". Note that if any other case entities exist within your instance that start with the same Case ID Prefix, it will change their sequence value as well.

Because this query can make changes to your database, please reach out to support@decisions.com or open a support ticket to receive the query which can alter the case entity's sequence. We STRONGLY recommend taking a database backup prior to running this query in addition to testing this on a development/lower level environment before being employed onto your Prod environment.

Hope this helps!

- Cody