Quillix Web Database Lookup

A Quillix Web database lookup is configured for specific Document or Batch Index Fields, and dynamically fills index fields with values already stored in an external database. The lookup reduces the amount of data entry a Quillix Web user must perform in order to index a batch or document. Unlike the automated version, however, a user has to initiate this type of lookup from Quillix Web. The user does this by placing his or her cursor into a field, entering an index value into the field, and then hitting the TAB key to exit the field.

Using Quillix Web, a database lookup can be initiated by any Quillix client user from anywhere in the world. The index value entered as the SQL query key is passed by means of a Web service to the external database. If a matching record is found in the database, the information is returned to the Quillix client, also by way of the lookup Web service, and loaded directly into the index fields.

Database Lookup and Index Validation functionality in Quillix Web is accomplished by configuring a database lookup for a specific field.  To configure a database lookup, check the Trigger a database lookup check box in the Index Fields pane under the field you wish to use to trigger the lookup.

Database Lookup Settings Wizard

1. Click on the Edit button to open the Database Lookup Wizard.

2. Select the option to Configure the Standard Web Database Lookup and click Next.

   

   Figure 1 - Web Database Lookup Wizard

3. Select the Data Source and provide the User ID and Password for the selected Data Source. Note: a valid 32-bit SYSTEM ODBC Data Source must be configured before completing this step. 

   

   Figure 2 - ODBC Data Source Settings

4.  Select Use the Wizard to Create a Simple Query then click Next.

5. Select the schema and table to use for the lookup from the drop down lists, then check each Quillix field to populate, choosing the corresponding column from the table to populate each field. Click next when all selections have been made.

   

   Figure 3 - Select the Database Table and Fields

6. Select Use the Wizard to Create a Simple Query then click Next.

7. Select the column to use for the "where" clause for the lookup, and the Quillix field to use for the query. Use the Add Condition button to add the condition.  Click next when all selections have been made.

   

   Figure 4 - Query Conditions

8. Check the desired General Settings check boxes for lookup behavior as follows:

Figure 5 - General Settings

9. 1. Prompt to clear key field if no records are returned: This option will cause the value entered in the lookup field to be cleared if no matches are found in the database.

   2. Clear all index fields included in the Where clause: This option will cause all additional key fields in the where clause to also be cleared.

   3. Prompt if multiple records are returned: This option will display a selection dialog if the lookup returns multiple records from the database.

   4. Clear the list before adding records: This option is only used if a field being populated is a pick list.  When set, this option will cause the existing list entries to be cleared before populating with results from the lookup.

10. Review the SQL Query and make any changes WITH CAUTION as desired, then click Finish.