Managing Master Data with webMethods OneData : Developing for webMethods OneData : OneData Hooks : Process Flow Designer : Process Items : Non-Interactive Process Items
Non-Interactive Process Items
Process Flow Designer provides the following non-interactive process items:
*Sequence. Fetches the value of a sequence to insert into an object.
*Action. Executes an action on a data object.
*CO Action. Executes an action on a conceptual object.
*Mapping. Maps attributes from multiple items for an action on an object.
*Custom Data. Provides users an option to execute a custom SQL query for retrieving data.
*Custom Java. Provides users an option to execute a custom Java code as part of the process flow.
The following sections describe the properties for each of the non-interactive process items.
Sequence Process Item Properties
Sequence process items fetch the value of a sequence to insert into an object. Only database sequences are supported. This process item is within the process component.
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.
Action Process Item Properties
Action process items execute an action on a data object. This process item is within the process component
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.
CO Action Process Item Properties
CO Action process items execute an action on a conceptual object. The CO Action process item is within the process component.
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.
Mapping Process Item Properties
Mapping process items map attributes from multiple items for an action on an object. This process item is within the process component.
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.
CustomData Process Item Properties
CustomData process items provide users with an option to execute a custom SQL query for retrieving data. This process item is within the process component.
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.
CustomJava Process Item Properties
The CustomJava process item provides user an option to execute custom Java code as part of the process flow.
Process Flow Designer does not validate Java code 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 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.
Copyright © 2011-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback