Introduction
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).
| Note |
|---|
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.
[mysqld]
transaction-isolation = READ-COMMITTED
|
| Panel |
|---|
| borderColor | green |
|---|
| borderWidth | 1 |
|---|
| titleBGColor | #ddffcc |
|---|
| borderStyle | solid |
|---|
| title | Definition |
|---|
|
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). |
...
ID Generator Field Properties
Edit ID Generator Field
...
| Name | Description |
|
|---|
| Form | Target form. The form selected will be used for "Field ID" attribute below. |  Image Added
Figure 1: ID Generator Tool Properties |
| Field ID | Optional field. You may specify a form field ID to be updated. |
| Record ID | Optional field. You may specify a record ID explicitly, otherwise, the process instance ID will be assumed. |
| Environment Variable Name | Name of the environment variable to be used to keep the running number. |
| Format | Determines the pattern of the generated value (e.g., "REF-?????" will yield "REF-00001") |
...
Figure 2: ID Generator Tool Properties
| Workflow Variable | The value generated can be saved into the corresponding workflow variable named here. | Info |
|---|
| title | Using 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 |
|
.code
...