Workflow Generator Wizard

Workflow Editor can be used not only as an organizing document for flow design, but also to automatically create a template for workflow processing. Launch the Workflow Generator Wizard in one of the following ways:

• Click the "Generate Workflow" button at the top of the screen
• Right-click in the Workflow Editor canvas - Click on the "Generate Workflow" menu

Note

The workflow editor can be accessed by selecting the "Workflow" menu from the "Side Menu".

Step 1. Target node/Component selection

The Workflow Generator Wizard creates a workflow button for the UI set in the "UI" property of node. Step 1 is to select the target node. Checking the box ON is the selection. Click the "Continue" button to move to Step 2. Override the UI of the selected node and define components such as buttons.

Item	Description
Status list	The status is displayed in a list format.
CRUD	CRUD can be turned ON/OFF. CRUD ON: In addition to WF, CRUD tables and actions will be generated. CRUD OFF: Only WF will be generated.
Target UI	Select where to create the detailed display UI.
Component	Select the component to be used when creating the table.

Note

The UI for the selected node will be overwritten, so definitions already created will disappear. Please customize the UI after it has been created in the Workflow Generation Wizard.

Step 2. Data list columns selection

Among the components that make up the workflow, select the columns to be displayed in the data list.

Note

• The column order of the data list columns can be changed. To change the order, drag and drop the rows to change the sort order.
• If [case_id] is not selected, the button to access case data will not be displayed in the LIST UI. Therefore, it is recommended that [case_id] be selected.

Step 3. Database Selection

 

In step 3, select the database to which the workflow application will connect. The database name selected here will be entered as an argument for the built-in function in the action written on the button. The database must have a built-in table for the workflow. If the built-in table does not exist in the selected database, the built-in table will also be generated.

Creates a table with the specified table name in the selected database.

Also select what to do about existing tables, excluded columns, and primary keys.

Item	Options	Reference
Database	Database of the selected execution environment
Table Name	Select tables included in the selected database	To create a new table, enter the new table name in the Table Name field and click the option labeled 「Add "Table Name"」.
Existing tables	1. Delete and Create 2. Update	1. If you select "Delete and Create", the existing table will be deleted and a new table will be created, so we recommend that you back up the table. 2. If you select "Update", the existing table will be updated with the added/updated columns.
Excluded Columns	1. Don’t Modify 2. Delete	1. If you select "Don't Modify", the excluded columns in the existing table will remain unchanged. 2. If you select "Delete", the excluded columns in the existing table will be removed.
Primary key column	Auto-create (ID)Select	1. If you select “Auto create (ID)”, the following columns will be created as the primary key. Constraints Column Name Data Type PK/AI id INT 2. If you select “Select”, select the component to be used as the primary key in the “Primary Key Component” field.
Primary Key Component	List of component IDs selected in step 1 and for which primary keys can be set	Create a table with the column of the selected parts as the primary key.The following components can be used as primary keys: 1. Text input 2. Number input 3. High precision number 4. Select box 5. Combobox

Click the [Continue] button to move to step 3.

Step 4. Select an option

Set whether to specify the database name directly in the SQL statement to be created.

Also, select whether to support action definition.

Item	Options	Reference
Assign a DB name to the SQL function to be generated	1. ON 2. OFF	1. When ON, the generated SQL will specify a database name for objects. 2. When OFF, it is assumed that an existing database will be used, and the generated SQL will not specify a database name for objects.
Action	1. Overwrite existing code 2. Comment out and append to existing code	1. If you select "Overwrite existing code", all of your action descriptions will be overwritten. 2. If you select "Comment out and append to existing code", blocks of existing code will be commented out as shown below, and the new code will be added above the existing commented out blocks of code. [Image of action code] new code1 new code2 new code3  //old code1 //old code2 //old code3

Note

• If you turn off “Assign a DB name to the SQL function to be generated”, be sure to configure [Existing Database] settings on the application screen.
• After processing, you can freely modify the UI and button actions. This function is an aid for creating workflow applications. Workflow applications can be created according to your own design.

Output result

UI Editor

UI	Component or UI	ID	Label	Display or action
User-created form UI	Text input	case_id	CASE ID	Display case ID data
	Text Input	status	STATUS	View the current status
	Button	{OperationID}	{Operation Label}	Press the button to perform the operation
List_{Target UI ID}	UI	List_{Target UI ID}	List_{Target UI ID}	Displays a list of data.
	Datagrid	data_list		Display the data list in a data grid.
	Datagrid Column	case_id	CASE_ID	The case ID will be displayed, and when you press it, you will be redirected to the details screen.
	Datagrid Column	{Target UI’s ComponentID}	{Target UI’s ComponentLabel}	The columns you selected in step 2 to display will be created.

Note

• For the columns of the data grid (data_list) of the list display UI (List_{Target UI ID}) generated during workflow creation, the column type “Text input” is automatically selected by the original component. After creating the workflow, manually correct the column type as necessary.
• When generated with CRUD OFF, the ID and label of the output list display UI will be “List_UI”.

Table

After you have completed all the steps, a table will be created according to the components you selected.
The column name will be the component ID.
The column data type and size will vary depending on the component, as shown in the table below.

Component	Data Type	M	D
Text Field	VARCHAR	100
Text Area	VARCHAR	1000
Number Field	DECIMAL	10	3
Big Number	BIGINT
Select Field	VARCHAR	100
Password	VARCHAR	100
Select	VARCHAR	100
Combobox	VARCHAR	100
Radio Button	TINYINT
Radio Group	VARCHAR	100
Checkbox	TINYINT
Checkbox Group	VARCHAR	100
Switch	TINYINT
Rating	INT
Slider	INT
Spreadsheet	LONGTEXT
Date Picker	VARCHAR	100
Time Picker	VARCHAR	100
Date Time Picker	VARCHAR	100
Data Grid	TEXT

Create WF with Execute Previous History

After creating a workflow, you can recreate it with the wizard settings from the previous time it was created.

1. Click the [Execute Previous History] icon in the upper right.
    

Note

• [Execute Previous History] is enabled if there is history from the previous creation.
• When using [Execute Previous History], the wizard dialog will not be displayed.
• If there are components that have been added since the previous creation, the following behavior will occur.
  The data grid in the list display UI will be updated by adding a column to the last column.
  Tables will be updated by adding a column to the last column.
• If there are components that have been deleted since the previous creation, they will be deleted from the action definition, the data grid in the list display UI, tables, etc.

Clear previous settings

You can clear the settings in the wizard when you created the workflow.  

1. Click the [Clear History] icon in the upper right.