By placing [Update Data] in the middle of a Workflow you can overwrite Business data on each Issue passing the Step. You can automatically set the "current time (Time of passing)", or the "Tax price" which refers to the "Price excluding Tax" that was entered at the upstream Step.
1. Usage Example of Data Auto-setting
- 1. Calculation of the relative value
Set the date of three days after the "document delivery date" which has been entered in the upstream process as the "deadline"
- 2. Unified Format
Automatically generates a string in accordance with the naming convention and set it as "invoice ID"
- If you want to automate more complex data processing you can use the [Script Task]
2. Setting a Formula for Calculation of Numerical Values
- a. Reference to Other Numerical Data
Calculate numerical values by referring to Numeric-type data or fixed real numbers
( (#q_numeric1 + #q_numeric2) * 0.05 - #q_table.summary['total'] ) / 30R2270: Numeric Output via EL syntax
3. Setting a Formula for Processing of Date Time
- a. Reference to Other Datetime Data
Calculate the date or time by referring to the Date-type data or Datetime-type data
#q_datetime.addHours(9)- b. Reference to the Workflow Platform's Administrative information
Calculate by referring to the Start time or the current time
#now.addDays(1).getFirstTimeInDate().addHours(9)R2271: Output of Date and Datetime Data via EL syntax
4. Setting the Selection Result
- a. Set a Fixed value
Set fixed values for the Choice ID of a Select-type Data Item
- b. Reference to Other Data Item
Set the selection result (Choice ID) referring to other Select-type data or String-type data
R2273: Auto-assignment to Select-type
5. Setting a Formula for Generation of a String
- a. Reference to Other Business data
Generate a string from String-type data or User-type data, etc.
Mr. #{#q_string1}
xyz-#{#dateFormatter.format('yyyy-MM-dd', #q_datetime)}
- b. Reference to the Workflow Platform's Administrative information
Generate strings from the name of the Business operation or the Started User, etc.
xyz#{#sformat('%06d', processInstanceSequenceNumber)}
R2272: Output of Strings via EL syntax
BPMN Icons: Update Data
-
#dateFormatter.format () is also available when you want to change the format of date and time information
- #dateFormatter.format (): format() method of "com.questetra.bpms.core.event.scripttask.DateFormatWrapper"
-
#sformat () is also available when you want to change the format of text string information arbitrary
- #sformat(): format() method of "java.lang.String"
6. Setting a User/Organization
- a. Set a Specific User/Organization
Set a specific user/organization by name or using selection tools
- b. Reference to Other Data Item
Set a user/organization by referring to User-type, Organization-type or String-type data via EL Syntax
R2274: Auto-assignment to User/Organization Type via EL Syntax
7. Clear the entered value
- a. Clear the entered value
Clears (deletes) the entered/selected value or attached file
- Values cannot be cleared for Discussion-type (append-only) and Guide Panel-type (display-only) Data Items