An auto-generated sequence value for a repository is controlled by the corresponding
sequence definition associated to the repository. When a new record is created in the
repository and no value for the auto generated id field is provided, the next sequence number
is selected from the sequence definition. Even though a sequence definition can be shared by
multiple repositories, it is recommended as best practice to create a separate sequence
definition for each repository. A repository sequence definition is defined as follows:
-
Log into EnterWorks Classic as a user assigned to the Administrator group.
-
Open the list of existing sequences by opening the Feature bar, opening the Model
Configuration tab, and selecting Sequences.
-
Open the sequence definition in the Sequence editor:
- To create a sequence definition, o
- Open the desired sequence definition for editing by selecting the definition,
opening the Action dropdown menu, and selecting Edit
-
The sequence definition's configuration options will be displayed. Edit them as
desired:
-
Name: (Required) The name of the sequence definition. Do not include
special characters in the name, such as & < > ".
-
Prefix: (Optional) You can add a prefix to auto-generated sequence
numbers. This can be useful for automatically generating GTIN values.
-
Starting Sequence: (Required) The first number in the sequence. Do not
set the Starting Sequence Number to a value the same as or lower than the
Current Max Sequence, otherwise as records are added, their sequence
numbers may be the same as the sequence numbers for records that already
exist.
-
Current Max Sequence: This is a displayed value only. It is not a
configuration option. It displays the highest number currently in the sequence. If this value is blank, no records have been generated yet that use this
sequence definition.
-
Click the Save button.
-
Sequences are securable objects and must be made accessible to the groups that need to
access them. If the security has not already been defined for this sequence or it needs
to be updated, do so: Define Access to Securable Objects.