Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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

 

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

...

Figure 2: ID Generator Field Properties

NameDescription
ID

Element ID (By declaring as "ref", a corresponding database table column "c_ref" will be created)

Warning
titleNote when using this element when the form is part of a workflow process

Do not set the id as "id" when the form is used as part of a workflow process. The value generated by this element will not be associated with process instance's ID.

LabelElement 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")

...