Filter Operators

Introduction

Filtering your report is one of the most important steps in InfoView Report Writing. Because the Data Warehouse has so much information in it, it is rarely the case that you'll need all of the rows in your chosen universe. The more precise your filters are, the faster your report will be and the less work you will have to do in later steps.

Query filters are very strong and can be very precise. This guide looks at operators, the words that define the type of logic for a filter such as equal to, greater than or between.

Filter Operators

Filters have 15 types of operators.

Screenshot of InfoView Query Panel filter operators drop-down menu

Operator Table

Operator Description
Equal to Select only rows where this object is equal to a single value
Not Equal to Select only rows where this object is not equal to a single value
Between Select only rows between these two dates or these two numbers
Not Between Select only rows not between these two dates or these two numbers
Matches pattern

Select only rows that match this set of characters in the exact order.

Note: This requires use of one or more wildcards (%), which act as a placeholder for one or more characters (e.g. 77463% )
Different from pattern Select only rows that do not match the entered set of characters in the exact order. This also uses wildcards.
Greater than Select only rows where a number or date is larger than the entered number or date
Greater than or Equal to Select only rows where a number or date is larger than or equal to the entered number or date
Less than Select only rows where a number or date is smaller than the entered number or date
Less than or Equal to Select only rows where a number or date is smaller than or equal to the entered number or date
In List (Default)

Select only rows where this object is equal to one or more entered values

Note: Multiple values should be entered separated by a single semicolon and no spaces (e.g. 404159;203154 )
Not In List Select only rows where this object is not equal to one or more entered values
Both/Except Mostly used in advanced queries
Is Null Select only rows where this field is empty of any values
Is Not Null Select only rows where this field is not empty of any values