AVEVA™ Instrumentation

Apply Advanced Grid Filters

Save PDF

TABLE OF CONTENTS

Apply Advanced Grid Filters

Save PDF

Last UpdatedSep 19, 2025
3 minute read

You can add or change an advanced filter to the current grid view. To do this, you must first open the Filter window.

To open the filter window

In the Grid Actions section of the Home Tab in AVEVA Instrumentation, click Filter.

The Filter window displays.

Add a New Criteria

Select the field by entering or selecting a value from the Field list.
Select a filter criteria from the Criteria list.
Enter a value in the Value option, or select from the Value list.

Add Additional Criteria

Select + Filter from the toolbar.

Another row of filter lists (Field, Criteria and Value) displays. Between the first and second rows the operator AND is displayed in blue text (meaning that only records that satisfy both of the criteria will be included after filtering has been applied).
If desired, change the AND operator to OR clicking on the operator itself. Doing so signifies thar that records that satisfy either of the criteria will be included after filtering has been applied.
Enter the details for additional criteria as required. Any number of additional criteria may be defined.
If desired, use the toolbar to change the order of filter criteria and to add brackets around them. For more information on the toolbar and on filter criteria, see below.

Apply the Filter

To apply the filter, click Apply.

Note: Some filter criteria, such as Begins With, use a wild card match to filter values. Do not supply any wild card characters such as '*' or '%' as AVEVA Instrumentation handles this for you.

More Information about Filter Criteria:

Filter Criteria	Description	Example Value	Comments
Exact Match	Field = Value	1234	Shows all records where Field = 1234.
Begins With - Partial Match	Field like XX*	XX	Shows all records where Field begins with two characters XX.
Ends With - Partial Match	Field like *XX	XX	Shows all records where Field ends with two characters XX.
Contains - Partial Match	Field like XX	XX	Shows all records where Field contains two characters XX.
In List	Field = A or B or C	A, B, C	Shows all records where Field exact matches any values in list.
Greater Than Or Equal To	Field ³ Value	1234	Shows all records where Field ³ 1234.
Less Than	Field < Value	1234	Shows all records where Field < 1234.
Less Than Or Equal To	Field £ Value	1234	Shows all records where Field £ 1234.
Greater Than	Field > Value	1234	Shows all records where Field > 1234.
Not Exact Match	Not Field =	1234	Shows all records where Field does not = 1234.
Not Begins With Partial_Match	Field like T	T	Shows all records not beginning with T.
Not Ends With Partial_Match	Field like T	T	Shows all records not ending with T.
Not Contains Partial_Match	Field like T	T	Shows all records not containing T.
Is Empty	Is Field = (nothing)		Shows all records where Field is empty.
Not Empty	Not Field = (nothing)		Shows all records where Field is not empty (no characters).
Not Null	Not Field = Null		Shows all records where Field is not Null.

Note: A database NULL means nothing has ever been entered in this field, whereas Empty means that current value is empty (no characters).

Command Buttons:

Apply	Exits the Filter window and applies the filter to the current grid.
Cancel	Exits the Filter window without changing any filters in the current grid.

Toolbar Commands:

+ Filter	Adds a new Filter row to the Filter definition.
- Filter	Removes the selected Filter row from the filter definition.
Change Join	Toggles the selected logical join between AND and OR.
+ (	Adds a left bracket to the filter expression.
- (	Removes a left bracket from the filter expression.
+ )	Adds a right bracket to the filter expression.
- )	Removes a right bracket from the filter expression.
- ( )	Removes all brackets.
Test Filter	Tests the Filter.
á Up	Moves a Filter row up.
â Down	Moves a Filter row down.
O Clear Filters	Clears all filters in the current grid.

AVEVA™ Instrumentation