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
This article explains how to create, apply, and manage filters in the FSGS tab within VDM. It also outlines the full list of available filter operators and introduces powerful date keywords for advanced time-based filtering.
What Is Filtering?
Filtering your View allows you to refine the results returned from your database, showing only the data you care about. This can be based on values, ranges, dates, or lists of items.
How to Create a Filter
Open your View and go to the FSGS tab.
In the Filter section, choose the desired Field from the dropdown.
Select the Operator from the operator dropdown.
Enter the Value you want to filter on.
5. Click the “+” button to add additional filters.
Tip: VDM automatically handles quotes for strings and dates—no need to manually add them.
Operator Options & Definitions
| Operator | Description |
|---|---|
| Equals | Matches exact values |
| Does not equal | Excludes specific values |
| Greater Than | Values greater than input |
| Greater Than or Equal To | Values ≥ input |
| Less Than | Values less than input |
| Less Than or Equal To | Values ≤ input |
| Starts with | Text begins with input |
| Ends with | Text ends with input |
| Contains | Text contains input |
| Does Not Start with | Text does not begin with input |
| Does Not End with | Text does not end with input |
| Does Not Contain | Text does not contain input |
| Is Null | Returns empty/null values |
| Is Not Null | Excludes null values |
| Is between | Value is between two inputs (e.g., 50 AND 100) |
| Is not between | Value is outside the given range |
| Is any of* | Matches any item in a list |
| Is none of* | Excludes all items in a list |
List Operator: Use the Create/Edit Value List option for managing long lists.
Parameters: Use Parameters for dynamic list population.
Special Date Filtering Keywords
VDM supports smart date keywords to dynamically handle date-based filters:
Today & Relative Days
@Date= today’s date@1DaysAgo= yesterday@30DaysAgo= 30 days ago@30DaysOut= 30 days from now
Weeks
@4WeeksAgo= 4 weeks ago@4WeeksOut= 4 weeks from now
Months
@6MonthsAgo= 6 months ago@6MonthsOut= 6 months in the future@Today4MonthsAgo= today’s day, 4 months ago@Today4MonthsOut= today’s day, 4 months in future@ThisMonth= from the 1st of this month to today@LastMonth= all of last month@LastDayofLastMonth= gets the final day of the previous month
Years
@3YearsAgo= 3 years ago@3YearsOut= 3 years from now@Today4YearsAgo= today’s date, 4 years ago@Today4YearsOut= today’s date, 4 years ahead
Day and Month Format
@1Day12MonthsAgo= 1st of the month, 12 months ago@1Day12MonthsOut= 1st of the month, 12 months out
Usage Examples
| Filter Statement | Result |
|---|---|
Assigned_Date = @Date |
Returns today's records |
Assigned_Date >= @30DaysAgo |
Returns records from the last 30 days |
Assigned_Date = @1DaysAgo |
Returns yesterday’s records |
Assigned_Date >= @7DaysAgo AND < @Date |
Returns last week (if today is Monday) |
Transaction_Date = @ThisMonth |
Returns current month's transactions |
Transaction_Date = @LastMonth |
Returns last full month’s transactions |
Assigned_Date <= @LastDayofLastMonth |
Returns records up to last day of previous month |
ACCOUNT_SELFPAY.Assigned_Date >= @1Day12MonthsAgo |
Returns one year’s worth of data from that day |
Summary
Filters are a powerful tool in FSGS that help you narrow down your results with precision. Whether you're filtering by text, numeric values, or using dynamic date logic, the FSGS filter system is flexible enough to handle a wide range of reporting needs.
Comments
0 comments
Please sign in to leave a comment.