Page Comparison

Image Modified
Then, connect the input and output nodes you will be using.
The Data Query object can be used in mapping like any other data lookup object group.
Image Modified

Anchor
call_data_query_object call_data_query_object

Call a Data Query Object within an Expression

Items that have default output parameters defined can be used without adding them onto the worksheet. They can be called via expressions in the format:

dataquery_name( arg1, arg2, … )

The arguments of this expression will be delivered as input parameters to the Data Query object specified.
To call a Data Query Object within an expression, start by editing a destination expression. You can choose a library item to be called from the autocomplete dropdown:

Image Modified
Alternatively, you can also drag and drop a Data Query item directly into the expression:

Image Modified
Next, set the input parameters:

Image Modified

Anchor
examples_dataquery examples_dataquery

Examples

Below are some more examples of particular types of Data Query Objects. 

Anchor
dbrequestexample dbrequestexample

DB Request

The DB Request element allows to use a DB procedure within your solution.
After dragging and dropping the DB Request element to your working area, please click "Settings" (the gear icon in the bottom-left corner):

Image Modified
The following dialog window can help you to choose the appropriate DB procedure and decide whether to let IWS do auto-mapping or not.

Image Modified
Click OK.
If you want to change input parameters manually, set them in the "Properties" window at the right.

Image Modified
You can give a Name to your DB Request element. It is used to construct the result status variable names. If the Name is not empty, the name_STATUS_CODE, name_CHANNEL_STATUS_CODE, and

name_STATUS_MESSAGE variables are created, and can be used in other expressions. See the following table for more details:

Anchor
dbrequestsqlexample dbrequestsqlexample

DB Request (SQL)

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":

Image Modified
The dialog window helps to specify additional parameters for the SQL statement:

Image Modified
Then enter the SQL query in the "Expression" cell:

Image Modified
The DB Request (SQL) element can have a Name. It is used to construct the result status variable names. If this attribute is not empty, the name_STATUS_CODE, name_CHANNEL_STATUS_CODE, and

name_STATUS_MESSAGE variables are created, and can be used in other expressions. 

The "Properties" window to the right allows to specify the parameters of the DB Request (SQL) element manually.

Anchor
runpanelexample runpanelexample

Run Panel

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:

Image Modified
The following dialog window will open. You can either scroll to the required panel or use quick search:

Image Modified
Once the panel is chosen, click OK.

IWS will automatically fill in several fields:

Image Modified
You can give the Run Panel element a specific Name. The Name is used to refer to the Run Panel element and to check execution results. If this attribute is not empty, the Name_STATUS, Name_STATUS_MESSAGE, and Name_PANEL_STATUS variables are created and can be used in other expressions.

The "Properties" window to the right allows to edit several parameters of the Run Panel element manually:

Image Added

Anchor
datalookup datalookup

Data Lookup

The Data Lookup provides the ability to perform lookups.
After dragging and dropping it to the work area, you can select the required lookup:

Image Modified
The following dialog window opens: 

Image Modified
You can either browse the file tree to find the needed lookup, or one can use Quick Search. IWS fills in several fields automatically, and you can fill in the input parameters manually, for example:

Image Modified
The Data Lookup element can have name parameters. A name is used to refer to the Data Lookup element, later, to check the execution results.

If this attribute is not empty, the Name_STATUS, Name_STATUS_MESSAGE, Name_RESULT and Name_LOOKUP_STATUS variables are created and can be used in other expressions.

The below table lists the possible values and descriptions for the name parameters.