Important Filtering Notes & Examples

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

In this article we will give detailed explanations of the operators inside the FSGS as well as examples how to setup your Value List for filter values. 

 

 

Operator Description & Usage

Equals ( = )

dbo.Orders.EmployeeID = 1 Returns data equal to the entered Value for the selected Field.

 

Does not equal ( <> )

dbo.Orders.EmployeeID <> 1 Returns data where it is not equal to the entered Value for the selected Field.

 

Greater Than ( > )

dbo.OrderDetails.UnitPrice > 1 Returns data greater than the entered Value for the selected Field.

 

Greater Than or Equal To ( >= ) 

dbo.OrderDetails.UnitPrice >= 1

Returns data greater than or equal to the entered Value for the selected Field.

 

Less than ( < )

dbo.OrderDetails.UnitPrice < 1 Returns data less than the entered Value for the selected Field.

 

Less than or equal to ( <= )

dbo.OrderDetails.UnitPrice <= 1 Returns data less than or equal to the entered Value for the selected Field.

 

Starts with ( LIKE )

dbo.Customers.ContactName LIKE 'C%' Returns data that starts with the entered Value for the selected Field.

 

Ends with ( LIKE ) 

dbo.Customers.ContactName LIKE '%A' Returns data that ends with the entered Value for the selected Field.

 

Contains

dbo.Customers.ContactName LIKE '%A%' Returns data that contains the entered Value for the selected Field.

 

Does not start with ( NOT LIKE )

dbo.Customers.ContactName NOT LIKE 'A%' Excludes data that starts with the entered Value for the selected Field.

 

Does not end with ( NOT LIKE )

dbo.Customers.ContactName NOT LIKE 'A%' Excludes data that ends with the entered Value for the selected Field.

 

Does not contain ( NOT LIKE ) 

dbo.Customers.ContactName NOT LIKE '%A%' Excludes data that contains the entered Value for the selected Field.

 

Is null ( IS NULL )

dbo.Orders.ShippedDate IS NULL Returns data where the selected Field is null.

 

Is not null ( IS NOT NULL )

dbo.Orders.ShippedDate IS NOT NULL Returns data where the selected Field is not null.

 

Is between ( BETWEEN )

dbo.OrderDetails.UnitPrice BETWEEN 50 AND 100 Returns data between two Values for the selected Field.

 

Is not between ( NOT BETWEEN )

dbo.OrderDetails.UnitPrice NOT BETWEEN 50 AND 100 Returns data not between two Values for the selected Field.

 

Is any of ( IN ) *

dbo.Orders.EmployeeID IN (1,2,3) Returns data that matches the entered list Values for the selected Field.

 

Is none of ( NOT IN ) *

dbo.Orders.EmployeeID NOT IN (1,2,3) Excludes data that matches the entered list Values for the selected Field.

 

 

Operators marked with * use, the Create/Edit Value List feature to manage your list:
mceclip1.png

 

 

mceclip0.png

 

 

 

  

Have more questions? Submit a request

Comments