Configuring the Infor Lawson Query node
Use this procedure to define the general properties of the Query node.
- Select the Infor Lawson Query start node. On the General tab, specify this information:
- Configuration name
-
Select the configuration to use for this activity. To use an existing configuration, select a name from the list. If you leave the field blank, the default configuration is used.
- Query string text box
-
This is the field where the query is displayed. You can specify a query manually, or use the Import or Build buttons.
Click Build to build a Data Service (DME) call using the Designer.
See Creating a query using the Infor Lawson Process Query Builder.
Click Import to use an existing Data Service (DME) call. You can save a query string for future use.
- Treat zero records as error
-
Select this check box to configure the node to throw an error when the query returns no records.
- Automatically encode values in variables
-
Select this check box to automatically encode the values in variables passed into the node.
- On the On Error tab, specify this information:
- What should happen on an error?
-
Select from the available options.
- Notify
-
Select this check box to send a notification when an error occurs. If this option is selected, you must fill out the notification details.
- Custom log entry
-
Select this check box to have a custom log entry in addition to the system-generated log entry.
- Select the Infor Lawson Query end node. On the Break Condition tab, specify any valid true/false conditions that must be satisfied to end the iteration.
Note:
If a variable is used as part of the condition, you must remove the surrounding brackets <! and >.