When creating external datasheets, you can add a query in the datasheet options to return a subset of data from a Microsoft Access, Oracle, PostgreSQL, SQLite, or SQL Server database. Any query supported by the database application can be used to import subsets of data to a datasheet or to update a datasheet linked to an external data source each time it is opened in QA Wizard Pro.
Note: You can also use script-generated queries to access data during script playback. See Retrieving external data with script-generated queries.
1. Use the Create Datasheet wizard to create an external datasheet. See Configuring external datasheets.
2. Select Query.
3. Enter the query.
Tip: You can create the query in the database application, copy it, and paste it in the Query field.
4. Click OK.
The datasheet opens and contains the returned data. If the datasheet is linked to an external data source, the query updates the data each time the datasheet is opened.
Example
In the following query, a subset of data is retrieved from a Microsoft Access database. The SELECT statement returns the First_Name, Last_Name, Email_Address, Company, and Phone_Number data. The FROM statement specifies that the data should be returned from the WysiCorpData table.
SELECT WysiCorpData.ID, WysiCorpData.First_Name, WysiCorpData.Last_Name, WysiCorpData.Email_Address, WysiCorpData.Company, WysiCorpData.Phone_Number
FROM WysiCorpData;
    |
|