...
ID Generator Tool allows one to increase value stored in Environment Variable by one. It is very often used to generate/keep a running number (e.g. application reference number).
...
You will only need to do this if you are using MySQL, as other databases already default to "READ-COMMITTED".
Run following queries in MySQL.
SET GLOBAL tx_isolation='READ-COMMITTED';
SET SESSION tx_isolation='READ-COMMITTED';...
ID Generator Field Properties
...
| Name | Description | |||||
|---|---|---|---|---|---|---|
| ID | Key in the field id. 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. |
Figure 1: ID Generator Tool Properties | ||||
| Label | Key in the label of this field.Mandatory field. | |||||
| Environment Variable Name | Name of the environment variable to be used to keep the running number. Joget will automatically create the environment variable in Properties & Export if the name does not exist. | |||||
| Format | Determines the pattern of the generated value (e.g., "REF-?????" will yield "REF-00001"). | |||||
| Hidden | Click the checkbox to hide this field in the form. | |||||
| Workflow Variable | The value generated can be saved into the corresponding workflow variable named here.
|
MySQL Isolation Level
| Note |
|---|
The isolation defines the way in which the MySQL server (InnoDB) separates each transaction from other concurrent running transaction in the server and also ensures that the transactions are processed in a reliable way. If transactions are not isolated then one transaction could modify the data that another transaction is reading hence creating data inconsistency. Isolation levels determine how isolated the transactions are from each other. You will only need to do this if you are using MySQL, as other databases already default to "READ-COMMITTED". Run following queries in MySQL. SET GLOBAL tx_isolation='READ-COMMITTED';
SET SESSION tx_isolation='READ-COMMITTED';You will also need to set the following in your my.cnf/my.ini file. |