| 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. |
ID Generator Field is used to produce a running number based on an Environment variable. To learn more about its usage, refer to Generate Reference ID.
Figure 1: Screenshot highlighting ID Reference Field in sample HR Expenses Claim app
Screenshots in this article obtained from http://localhost:8080/jw/web/console/app/hr_expense/1/form/builder/hr_expense_new
Figure 2: ID Generator Field Properties
| Name | Description | |||||
|---|---|---|---|---|---|---|
| ID | Element ID (By declaring as "ref", a corresponding database table column "c_ref" will be created)
| |||||
| Label | Element Label to be displayed to end user. | |||||
| 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 3: ID Generator Field Properties - Advanced Options
| Name | Description | |||||||
|---|---|---|---|---|---|---|---|---|
| Hidden? | Determines if the element should be made visible in the form. | |||||||
| Workflow Variable | If the form is part of a workflow process, upon saving of the form (by clicking on "Save as Draft" or "Complete" button). The value in this input field will be saved into the corresponding workflow variable named here.
|