Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.
Article Goal
Provide a detailed reference of the available FSGS operators in VDM, including usage examples and guidance on using the Create/Edit Value List feature with multi-value operators.
What Are Operators?
Operators are comparison tools used in filters to return or exclude specific data based on user-defined conditions. These operators are commonly used when building or editing Views to control which records appear in the result set.
Why Use Operators in Filters?
Operators give you precise control over your queries. Whether you're looking for exact matches, partial strings, ranges, or lists of values, operators help structure your filter logic efficiently and clearly.
Tip: Combine multiple operators across fields for advanced filtering logic (e.g., use
>=withANDto filter by date ranges and minimum amounts).
Operator Descriptions and Examples
Each of the following operators can be used directly in filter conditions when building a View.
| Operator | Example | Description |
|---|---|---|
= Equals | dbo.Orders.EmployeeID = 1 | Returns data equal to the specified value |
<> Does Not Equal | dbo.Orders.EmployeeID <> 1 | Returns data not equal to the specified value |
> Greater Than | dbo.OrderDetails.UnitPrice > 1 | Returns data greater than the specified value |
>= Greater Than or Equal To | dbo.OrderDetails.UnitPrice >= 1 | Returns data greater than or equal to the value |
< Less Than | dbo.OrderDetails.UnitPrice < 1 | Returns data less than the specified value |
<= Less Than or Equal To | dbo.OrderDetails.UnitPrice <= 1 | Returns data less than or equal to the value |
LIKE Starts With | dbo.Customers.ContactName LIKE 'C%' | Returns data that starts with the entered value |
LIKE Ends With | dbo.Customers.ContactName LIKE '%A' | Returns data that ends with the entered value |
LIKE Contains | dbo.Customers.ContactName LIKE '%A%' | Returns data that contains the entered value |
NOT LIKE Does Not Start With | dbo.Customers.ContactName NOT LIKE 'A%' | Excludes data that starts with the value |
NOT LIKE Does Not End With | dbo.Customers.ContactName NOT LIKE '%A' | Excludes data that ends with the value |
NOT LIKE Does Not Contain | dbo.Customers.ContactName NOT LIKE '%A%' | Excludes data that contains the value |
IS NULL | dbo.Orders.ShippedDate IS NULL | Returns records where the field is null |
IS NOT NULL | dbo.Orders.ShippedDate IS NOT NULL | Returns records where the field is not null |
BETWEEN | dbo.OrderDetails.UnitPrice BETWEEN 50 AND 100 | Returns values between two numbers (inclusive) |
NOT BETWEEN | dbo.OrderDetails.UnitPrice NOT BETWEEN 50 AND 100 | Returns values outside the defined range |
IN (Value List) | dbo.Orders.EmployeeID IN (1,2,3) | Returns data matching any value from a list |
NOT IN (Value List) | dbo.Orders.EmployeeID NOT IN (1,2,3) | Excludes data matching any value from a list |
Note: Operators marked with IN or NOT IN rely on the Create/Edit Value List tool or parameter values for managing multi-value filters.
Using the Create/Edit Value List
To use IN or NOT IN:
Open your filter and select the field.
Choose the IN or NOT IN operator.
Click Create/Edit Value List to build your list of accepted values.
Save your selection to apply the filter.
Tip: Use copy-paste or import from Excel to quickly populate long lists in the Value List editor.
Article Summary
This guide provides an overview of the most common operators used in VDM’s Field Selection Grid System (FSGS). These tools help you write precise, flexible filter conditions—ranging from simple matches to multi-value lists and string-based queries. For IN and NOT IN Logic, the Create/Edit Value List feature provides an efficient way to manage large sets of values.
Comments
0 comments
Please sign in to leave a comment.