Building Queries

Before you define a query to access certain data in a data-driven test case, there are several steps you need to complete. for additional information, see Using the Data Driven Workflow for more information.

Respond to the prompts on the Specify Rows dialog box to create a query for a table. The following are examples of simple queries:

  • To find and run the records of customers whose customer ID number is 1001: (CUSTID = 1001)
  • To find and run the records of customers whose names begin with the letters "F" or "G": (CUST_NAME LIKE ‘F%’) OR (CUSTNAME LIKE ‘G%’).

See the description of the enter values area in the Specify Rows dialog box to see examples of more complex queries.