Oracle - Lookup

This module can also be used for lookup purposes, this makes it possible to use values that are stored in the Oracle database to populate a list with lookup values a user can select from for metadata entry.

The user will be asked to provide Oracle Database connection settings when Oracle is selected as the Module for populating the list-items for the lookup question. After providing the connection settings the user will be able to select what Source should be used for populating the list-items, the Source is a selection of all tables that are stored in the Oracle database. Subsequently the metadata value and Display text column of the lookup question are populated with Table Columns of the Table selected as the Source. The Display text column is the Database Table column with values that will be displayed on the touch screen of the scan device where the Metadata value column is the Database column with values that will be used as metadata within the application.

A Description can be selected for the list-item, this can be a fixed value that will apply on all list-items or this can be a Table column to provide a description that only applies on the selected list-item. This description will be displayed on the touch screen of the scan device. Using the Filter functionality it is possible to make a subselection so not all records stored in the Oracle database table will be used for populating the Lookup question. It is possible to specify the filter using the wizard:

A default list-item can be selected either by Default metadata value or Default display text. Other than selecting from the Lookup list the user will also have the option to enter a value using the keyboard. If the entered value does not exists in the lookup list an Error message will appear on the touch screen of the scan device, the error message can be specified in the error message box.

Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Security Code Security Code
Related Articles RSS Feed
Oracle - Upload properties
Viewed 1115 times since Tue, Jan 14, 2014
Oracle - Store
Viewed 1542 times since Tue, Jan 14, 2014
Oracle Overview
Viewed 1123 times since Wed, Jan 15, 2014
MENU