Property | Description |
Name | Name of the sequence item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters. |
Sequence Logic | Logic or query for evaluating the next value of the sequence, for example, SELECT group_seq.NEXTVAL FROM DUAL. |
Sequence Type | Type of Sequence. Only available for an SQL sequence. |
Comments | Comments or description to be attached to the process item. Informational purposes only. |
Property | Description |
Name | Name of the action item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters. |
Process Component | Process component from which data must be retrieved for the action. |
Data Source Item | Form or DataGrid from which data is received for the action. |
Data Object | Required. Data object on which to execute the action. |
Action | Action to execute: Insert: Inserts the row into the data object. Update: Updates the corresponding row in the data object. Delete: Deletes the corresponding row in the data object. |
Comments | Comments or description to be attached to the process item. Informational purposes only. |
Property | Description |
Name | General tab. Name of the CO action item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters. |
Conceptual Object | Required. General tab. The conceptual object name on which to execute the action. |
Comments | General tab. Comments or description to be attached to the process item. Informational purposes only. |
Attribute | Mapping tab. List of all the objects constituting the conceptual object selected. |
Components | Mapping tab. Component(s) to which these objects need to be mapped. |
Item | Mapping tab. Items present in the selected component(s) to which these objects need to be mapped. |
Property | Description |
Name | General tab. Name of the mapping item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters. |
Data Object | General tab. Data object from which the attributes are inherited. Required attribute. |
Comments | General tab. Comments or description to be attached to the process item. Informational purposes only. |
Attribute | Mapping tab. Attributes of the selected data object. Populated when the data object is selected. |
Components | Mapping tab. Component to which Mapping Item attributes need to be mapped. |
Item | Mapping tab. Items present in the selected component to which Mapping Item attributes need to be mapped. |
Values | Mapping tab. Attributes present in the selected item to which Mapping Item attributes need to be mapped. |
Auto Populate | Mapping tab. Once the component and item are selected, Auto Populate completes where the attribute item selected on the first row matches the data object attribute. |
Note: | Process Flow Designer does not validate Java code defined in the SQL query when saving or updating the process flow. These validations are performed during the run-time of process flow hooks. |
Property | Description |
Name | General tab. Name of the custom data item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters. |
Custom Data Type | General tab. Select Display Grid to display the resulting query. To use the resulting query as an input for subsequent steps, select Custom Dataset. |
Selection Type | General tab. User selection option for the records displayed. Single: Provides radio button. Multi: Provides check boxes for multiple rows selection. This is only valid if Custom Data Type is Display Grid. |
Comments | General tab. Comments or description to be attached to the process item. Informational purposes only. Optional. |
SQL | SQL tab. SQL query for fetching the data from the table. The attributes in the SQL must be mapped to an alias that is defined in the Attribute tab. For example, Select name as NAME from city. In this SQL, you can also refer to dynamic values acquired in previous process components. The syntax is the same, for example, xyz = {ProcessComponentName#ProcessItemName#AttribueName} |
Attribute | Attribute tab. Attributes that store the result of the SQL query that is passed to subsequent steps. |
Delete | Attribute tab. To delete an attribute, if required. Click Add Attribute to add the attribute to delete. |
Property | Description |
Name | General tab. Name of the custom java item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters. |
Type | General tab. Select Execution if there is no branching involved after the Java source code is executed. Select Decision if the process flow has to be branched after the code is executed. |
Comments | General tab. Comments or description to be attached to the process item. Informational purposes only. Optional. |
Java Source Code | Java Source Code tab. Custom Java Code to be executed. For examples of Java code, see Process Flow Java Code Samples. |
Attribute | Mapping tab. Attributes used in the Java source code for inputting and outputting data. For examples of Java code, see Process Flow Java Code Samples. |
Components | Mapping tab. Components to which the custom Java item attributes are mapped. |
Item | Mapping tab. Items present in the selected Component to which custom Java item attributes are mapped. |
Values | Mapping tab. Attributes present in the selected item to which custom Java item attributes are mapped. |