Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Configure ID Generator Tool

Image RemovedImage Added

Figure 1: ID Generator Tool Properties

NameDescription
Form

Choose the Target form.

Field ID

Form field id. Only alpha-numeric and underscore characters allowed. Mandatory field.

If you use "id", the form will save with the "id" primary key in running sequence. Joget will not create the "id" in UUID format.

Record IDKey in the label of this field. Mandatory field.
App Variable Name

Name of the app variable to be used to store the running number. Joget will automatically create the app variable if the name does not exist. Only letters (a-z and A-Z), numbers (0-9) and underscore (_) are allowed in the App Variable Name field.

Do ensure your App Variable Names are unique for each form in your app (meaning for each form that is mapped to a different database table name).

If you are using the ID Generator Field as "id", meaning it is a primary key value, be careful not to override the app variable value when importing apps: do not click the "Show Advanced Options > Override app variables" checkbox in Import App screen.

Format

Determines the pattern of the generated value (e.g., "REF-?????" will yield "REF-00001").

Workflow Variable

The value generated can be saved into the corresponding workflow variable named here.

Info
titleUsing a non-existent Workflow Variable name

You will get the following warning with the name printed out (e.g. status) in the server Joget log if you attempt to map to a non-existent Workflow Variable:

context attribute status does not exist in process context - adding new attributes to the process context is not allowed

Distributed Unique ID

Generates a distributed sequential unique ID.

Info

It is advisable to use Distributed Unique ID when dealing with high loads of ID generation to avoid performance bottleneck.



Isolation Level For MySQL Database

...