The Interview Selection ODBC Module

With the Interview Selection ODBC (Open Database Connectivity) module, a selection list can be shown in the device display from which the user must select an entry. The text or value of the selected entry is stored in a freely definable variable that can be used in the further course of the workflow (e.g. in the The Decision Module).

If the contents of the selection table are to be entered directly in the module without an external source, use Interview Selection Module.

The module can occur several times in the workflow.

Interview modules can be called at any point in the workflow since version 4.13.

Start module

The Interview Selection ODBC Module

The Decision Module

The module can be connected to all modules (this can result in nonsensical workflows).

No restrictive modules.

Successful: In this case, the module follows that is to be executed after successful input or selection.

Cancel: In this case, the module follows that is to be executed if the user has actively terminated the interview by pressing the Cancel button.

Time-out: In this case, the module follows that is to be executed if the input has not been completed after the time-out period specified in the module settings.

The ODBC connection settings depend on the driver for the ODBC data source (and its version). They can differ quite considerably. The page https://www.connectionstrings.com can be of help with this.

Please note that reading from files via ODBC is not recommended. The ODBC driver is not part of IQ4docs support.

Enter the text to be displayed above the selection list (for example, Select a document type.)

Specify the variable name in which the variable value of the selection list entry that the user selected on the device is to be stored. For example, if you enter DocType, you can then use the variable with %DocType% in the rest of the workflow.

The name of the variable must not contain special characters. Allowed are small and capital letters (no umlauts or similar), numbers and the dot ".".
If the variable name is used in several places, all places can influence the variable value.

Here you can set a period of time in minutes after which the module will continue with the Time-out output if the user does not make an entry in the interview. The time runs independently of keystrokes, it is considered completed when the Continue button on the device is pressed (i.e. the user must have fully completed the input in this time).

The value 0 stands for no time-out (the time for input on the device is unlimited).

Enter the driver-specific connection string here. Specify it in one line with no line separation. Example:

  • Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

The syntax of the SQL statement also depends strongly on the connection string used. Specify variables in the usual notation %VariableName%.

The first two fields of the result list are used. The first field is used as the variable value, the second field as the displayed text. If the result list has only one field, it is used as the displayed text and the variable value.

Examples:

  • Select ID, name from selection table where login='%username%'.

  • Select name from selection table

  • Select * from selection table

You can check the ODBC connection by using a valid SQL statement and specifying actual values for variables used. The results are provided separated with | (if there is only one result, the value is output followed by the | character). Example:

  • Select name from table where No.='005'

The WorkflowService knows all information about a workflow (created in the Workflow Editor). It ensures that the process is adhered to and forwards information to the subsequent modules or their services in the workflow. Its log file is Logs\WorkflowService.log.