VI Filter Process Object

Object Attributes

You set attributes for the Filter process object in the object attributes pane.

Attribute	Description
Input	Defines the object from which the data flow arrives. Use one of the following methods to attach the Filter object to an input data flow object: Right-click the input data flow object, and click New Object after this > Process > Filter. Place a Filter object on the task flow, and click its Input attribute's browse button. Move the pointer to the task flow, and note that a dotted-line connector is attached to the Filter object. Attach this connector to the input data flow object. NOTE: The Filter object's Input attribute is now populated with the name of the input data flow object.
Action	Determines if the filtered rows are kept or discarded: keep (default)—Passes the filtered rows along the data flow discard—Removes the filtered rows from the data flow
Case_Sensitive	Controls whether comparisons are case-sensitive. true—Comparisons are case-sensitive. false (default)—Comparisons are case-insensitive.

Attribute

Description

Input

Defines the object from which the data flow arrives. Use one of the following methods to attach the Filter object to an input data flow object:

Right-click the input data flow object, and click New Object after this > Process > Filter.
Place a Filter object on the task flow, and click its Input attribute's browse button. Move the pointer to the task flow, and note that a dotted-line connector is attached to the Filter object. Attach this connector to the input data flow object.
NOTE: The Filter object's Input attribute is now populated with the name of the input data flow object.

Action

Determines if the filtered rows are kept or discarded:

keep (default)—Passes the filtered rows along the data flow
discard—Removes the filtered rows from the data flow

Case_Sensitive

Controls whether comparisons are case-sensitive.

true—Comparisons are case-sensitive.
false (default)—Comparisons are case-insensitive.

Comments

Each object has an area where you can enter comments.

It is a DI best practice to enter a note for every object in a VI script. You can set a VI preference to give a warning for each object without a note. For more information, see Visual Integrator Preferences.

Filter process object with comments

Column Grid

The Filter column grid displays the input columns from the input data flow where you can set the filter criteria.

Attribute	Description
Input Column	Displays the name of each input column. This attribute is read-only.
Source Object	Displays the name and object type of the source object. Double-click the Source Object for a column to change the task flow focus to that object.
Edit Filters	Defines filters for the input columns: Click the values button for the column that you want to filter. A values dialog box opens with the column name in the title bar. Enter values in the dialog box. Press Enter between each value. Click OK. The filter values now appear in the Filters column, and the number of values displays on the values button. Repeat for additional columns as required.
Filters (semicolon separated)	Displays the filter values for each column. You can enter or edit values here. Separate each value with a semicolon.
Filter on Null	If selected, filters the column on null values.
quickview	If selected, specifies that the values are interpreted as QuickView parameters so that the value All Values matches any string, and all rows are matched for the column. This attribute is useful in tunnel scripts that are passed filter values from QuickViews.