...
The following dialog window can help you to choose the appropriate DB procedure and decide whether to let IWS do auto-mapping or not. \
Click "OK".
If you want to change input parameters manually, set them in the "Properties" window at the right.
...
Variable | Possible Values and their Description |
|---|---|
name_STATUS_CODE | 0 (Success) |
name_CHANNEL_STATUS_CODE | If name_STATUS_CODE is not 0, this variable will contain a channel specific status code. |
name_STATUS_MESSAGE | Contains the status message. |
| Anchor | ||||
|---|---|---|---|---|
|
The DB Request (SQL) element allows to use a SQL statement in the rule to interact with the database. After drag-and-dropping the DB Request element to the work area, please click "Settings":
...
Variable | Possible Values and their Description |
|---|---|
name_STATUS_CODE | 0 (Success) |
name_CHANNEL_STATUS_CODE | If name_STATUS_CODE is not 0, this variable will contain a channel specific status code. |
name_STATUS_MESSAGE | Contains the status message. |
The "Properties" window to the right allows to specify the parameters of the DB Request (SQL) element manually.
| Anchor | ||||
|---|---|---|---|---|
|
The Run Panel element allows to execute a panel and retrieve the data received from the STAR engine.
After drag-and-dropping Run Panel to the work area, click "Settings" button in the bottom-left corner to select a panel:
...
Once the panel is chosen, click OK.
IWS will automatically fill in several fields:
...
The "Properties" window to the right allows to edit several parameters of the Run Panel element manually:
| Anchor | ||||
|---|---|---|---|---|
|
The Data Lookup provides the ability to perform lookups.
After dragging and dropping it to the work area, you can select the required lookup:
...
The below table lists the possible values and descriptions for the name parameters.
Variable | Possible values and descriptions |
|---|---|
Name_LOOKUP_STATUS | 0 – The panel was not executed. For example, the Data Lookup execution condition did not evaluate to TRUE. 1 – Success with data. 2 – Success with no data. -1 – Error. |
Name_STATUS_MESSAGE | Success. Query returned no data. Error. |
Name_STATUS | 1 – Success with data. 101 – Success with no data. Other values – error. |
Name_RESULT | The results of the lookup. |