Important Filtering Notes & Examples
Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
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:
Comments
0 comments
Please sign in to leave a comment.