Filtering Tab - Edit Legacy Property Loader Dialog Box
- Updated2025-07-21
- 2 minute(s) read
Filtering Tab - Edit Legacy Property Loader Dialog Box
Filtering Tab
Use the Filtering tab of the Edit Property Loader dialog box to filter the data the SQL statement returns so you load values only from rows that contain specific column values.
The Filtering tab contains the following options when you select Database in the Data Location ring control:
- Column List Source —The name of the variable or property in which to store the list of column value comparisons. The variable or property must be a DatabaseColumnValue array.
- Only Import Rows that Match the Specified Column Values —When you enable this option, the step loads only the rows that match the specific column values. When you disable this control, the Column Values section is dimmed.
-
Values
—The column values that each row must match. The Name/Number, Value, and Format String controls specify the settings for the currently selected mapping. Use
New
,
Cut
,
Copy
, and
Paste
to create a new item in the list, remove items from the list, and rearrange the items in the list.
- Name/Number —An expression TestStand evaluates at run time to determine the name of the column. To refer to a column by the order of the column in the SQL statement, specify an expression that returns a one-based number without surrounding quotes.
- Value —An expression TestStand evaluates at run time to determine the filter value of a column. Include the <FILE> or <SEQUENCE> tag within a value expression to instruct TestStand to automatically substitute the name of the sequence or file on which the step operates. To insert the <FILE> or <SEQUENCE> tag, select it from the drop-down list.
- Format String —Specifies how to convert a string value when comparing a column value to a string expression. Typically, you use this control when comparing data from a column that is of the date-time or currency type.
- Create Columns —Launches the Create Columns dialog box, in which you can add new columns to a database table. TestStand automatically populates the dialog box with the list of any column names that you specify and that the SQL statement does not return.
Use the Expression Browse button to launch the Expression Browser dialog box for controls which contain TestStand expressions .