Reference › Test Case Reference › Filter Descriptions › Database Filters › Extract Value from JDBC Result Set

Extract Value from JDBC Result Set

The Extract Value from JDBC Result Set filter lets you store the text of a specific JDBC result set value in a property. You can create this filter either manually from the filter list or by using the embedded filter commands on a result set response.

To create the filter manually:

Complete the following fields:

Filter in

The name of the property to consider as the last response for the step. If the property is not in the pull-down menu, you can enter it. The property must exist.

Column (1-based or name)

The index or name of the column (field).

Row (0-based)

The row to retrieve the value. This field is a zero-based index.

Property

The name of the property where the value in the cell at the row/column intersection is stored.

Filter Run Results

Displays the property and values that result from running the filter.

Run Filter

To run and execute the filter, click Run Filter. The results appear in the Filter Run Results section.

To create a filter from a result set response:

Follow these steps:

1. Display the step response that contains the result set.
2. From the result set, select the cell of the value to store in the filter.

   

3. Click Generate Filter , as the arrow in the previous graphic shows.
4. In the dialog, enter the property key:

   

5. Click OK.

The filter to store the value sbellum in the property theLogin is created.