Help > Setting up ReadSoft Capture Framework > Connecting master data > Creating and testing a database query

Creating and testing a database query

Note: Currently master data cannot be used with Web Verification.

  1. Using the XBOUND Management Center, open a console containing the Validation Designer. (For information about working with consoles, see XBOUND Help.)
  2. Under Process Navigation, select a process.
  3. Click the Check out button ().

  4. Select File > Queries.
  5. Click Add. Or select a query and click Edit.
  6. In the Edit query dialog, specify the appropriate settings.

    Here you can also configure the database query to:

    Closedlimit the results

    After Return type, select one of these options:

    • All results: All search results are returned.

    • Unique results: A search result is returned only if it is unique.

    • First result: Only the first result is returned.

    Closedfilter master data

    1. Select the row representing the database column containing the master data to filter.

    2. Select the Filter box for that row, and type the name of the XBOUND cell in the XBOUND Field/Table Column column.

    3. Type a value in the Test value column.

    4. Click Save and test to check if the filtering has the desired result.

    To use a query in Verification, use the Validation Designer to connect the query to a TextBox (using the LookupQuery setting) or to a ComboBox (using the DataSource setting). Then you can use the IsInQuery and GetQueryData rules to check the presence of master data or provide it.

    Closedignore duplicate entries

    Handling of duplicates is controlled by the Allow duplicates option.

    transfer master data to XBOUND fields

  7. Click Save and test.

Querying master data: Overview