These are configuration formats for automatically assigning values to String-type Data Items. You can use fixed values, data references and App/Process reference information to assign values to String-type Data Items. You can also use formatting functions to specify the output format, and functions to calculate JSON/XML escapes and hash values.
BPMN Icon: ［Service Task (Data Assignment)]
Workflow Variables
Workflow Platform
Application Root URL (System variable)
| Format | Assigned value |
|---|---|
| ${var[applicationRoot]} | https://sample.questetra.net/ |
App
App ID
| Format | Assigned value |
|---|---|
| #{processModelInfoId} | 12 |
App Name
| #{processModelInfoName} | Inquiry-handling flow |
Process
Process ID
| Format | Assigned value |
|---|---|
| #{processInstanceId} | 12345 |
| p#{processInstanceId} | p12345 |
| #{#sformat('%d', processInstanceId)} | 12345 |
| #{#sformat('%04d', processInstanceId)} | 12345 |
| #{#sformat('%06d', processInstanceId)} | 012345 |
Process Sequence Number (Application variable)
| #{processInstanceSequenceNumber} | 67890 |
| #{#sformat('%06d', processInstanceSequenceNumber)} | 067890 |
| xyz#{#sformat('%06d', processInstanceSequenceNumber)} | xyz067890 |
Process Start Time
| #{processInstanceStartDatetime} | 2020-03-14 09:45:00 |
| #{#format(processInstanceStartDatetime, 'dd.MM.yyyy HH:mm (E) Z')} | 14.03.2020 09:45 (Wed) -0500 |
| #{#format(processInstanceStartDatetime, 'M.yy')} | 3.14 |
Process Start User
| #{processInstanceInitQuserName} | SUZUKI Ichiro |
| #{processInstanceInitQuser?.getEmail()} | suzuki@example.com |
Process Start Organization
| #{processInstanceInitQgroupName} | Sales |
| #{processInstanceInitQgroup?.getEmail()} | sales@example.com |
Data Items
String-type
| Format | Assigned Value |
|---|---|
| #{#q_string} | ABC, def |
Numeric-type
| Format | Assigned Value |
|---|---|
| #{#q_numeric} | 12,345.67 USD |
| #{#sformat("%1.1f", #q_numeric)} | 12345.7 |
Select-type
| #{#q_select_radio} | Brazil |
| #{#q_select_radio?.![value]} | br (choice ID of the selection) |
| #{#q_select_check} | Japan, Brazil (display labels of the selections) |
| #{#q_select_check?.![value]} | ja, br (IDs of selection) |
| #{#q_select_check?.get(1)} | Brazil (the second choice label) |
| #{#q_select_check?.get(0)?.value} | ja (the first choice ID) |
Date/Datetime-type
| #{#q_date} | 25020-03-14 (Date-type Y/M/D） |
| #{#q_datetime} | 2020-03-14 23:45 (Datetime-type) |
| #{#format(#q_datetime, 'dd mm, yyyy')} | 14 03, 2020 |
File-type
| #{#q_file} | ((file name)) |
User-type
| #{#q_user} | SUZUKI Ichiro <suzuki@example.com> |
| #{#q_user?.name} or #{#q_user?.getName()} |
SUZUKI Ichiro |
| #{#q_user?.id} or #{#q_user?.getId()} |
13 |
| #{#q_user?.email} or #{#q_user?.getEmail()} |
suzuki@example.com |
Organization-type
| #{#q_org} | Sales <sales@example.com> |
| #{#q_org?.name} or #{#q_org?.getName()} |
Sales |
| #{#q_org?.id} or #{#q_org?.getId()} |
5 |
| #{#q_org?.email} or #{#q_org?.getEmail()} |
sales@example.com |
Discussion-type
| #{#q_discussion} | ------- [2020-02-07 13:29] <NAKAMURA Haruko> Hello, Good-bye (Assigning to single-line will result in an error) |
Table-type
| #{#q_table} | 2 row(s) |
| #{#q_table?.get(0, 2)} | Cash |
| #{#q_table?.getSummary()?.getCol(1)} | $162.50 |
Guide Panel-type
| n/a | (Display only) |
Functions
| Format | Assigned value |
|---|---|
| #{#escapeEcmaScript(#q_json_data)} | ((JavaScript escaped string)) |
| #{#escapeXml(#q_xml_data)} | ((XML escaped string)) |
| #{#sha256(processInstanceTitle)} | ((Hash string)) |
| #{#randomString(12)} | pJBAzTDft8wT ((12 alphanumeric characters： [0-9a-zA-Z]{12})) |
| #{ #join( #q_table?.rows?.![ #join(cols, ' | ') ], #NL) } |
Transportation: taxi|12.50|Cash Transportation: Airplane ticket|150.00|Credit Card ((Concatenate and output cell values of Table-type data)） |
Notes
- The Expression Language used for the variable is based on the implementation of SpEL (Spring Expression Language)
- Format with multiple variables can be set to String type Data
- e.g. If you set 'Process ID is #{processInstanceId}. Process Sequence number is #{processInstanceSequenceNumber}', the values of 'Process ID is 12345. Process Sequence number is 67890' will be assigned
- If there is a conflict such as when multiple lines of data is assigned to single-line String-type, will result in an error
- If you do not set anything as the format settings, a blank will be assigned (Data will be deleted)
- '%04d' (decimal notation plus 4 Digit zero (0)Padding) is a processing to make it in 4 letters by adding '0'
- Also works with an old format using the data definition number (data ['9']) instead of the field name (q_numeric)
Comments
0 comments
Please sign in to leave a comment.