Report Filter Glossary
- 04 Feb 2025
- 4 Minutes to read
- Print
- DarkLight
Report Filter Glossary
- Updated on 04 Feb 2025
- 4 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Report filters can be added to limit and display only relevant information for the user on a Report. Below is a list of some available filtering options and their categories.
For more information, such as adding a filter to a Report, please visit Adding a filter to a report or Rule filter on a Report for an example of how to create a rule filter.
Report Filter list
Entity Filters | Function |
---|---|
Archived | Filters entities based on the is_archived field |
Created by me | The current user created the entity |
Created within X days | Filters entities based on if they were created within X amount of days |
Edited within X days | Filters entities based on if they were edited within X amount of days |
Hidden | Filters entities based on if the Hidden field for the entity is true |
Limit to X Entities | Limits the number of entities to be displayed on the Report |
Modified by me | Filters entities based on if they were last modified by the current user |
Not in Folder | Filters entities based on if they exist are not found in the same folder as the Report. |
Recently Created | Filters entities based on if they were recently created. Can set the count of recently created entities to display |
State Filter | Filters based on a chosen state |
Text Search | Filters entities based on a text search on the Name and Description fields |
Field Filters | Function |
---|---|
[Field Name] Filter | This filter is only available on string fields, allowing the filter's condition to be edited at runtime. The conditions available are Equals, Does Not Equal, Contains, Is Not Empty, Is Empty, Starts With, Ends With, Does Not Contain, Does Not End With, and Does Not Start With. |
Does not Equal | The data field's value does not equal the filtered value. |
Contains | The data field's value contains the filtered value |
Contains in List | A value exists within a specified list. |
Ends With | The data field's value ends with the filtered value |
Equals | The data field's value equals the filtered value |
Not Empty | The data field's value is not empty, i.e., it contains any value. |
Empty | The data field's value are empty |
Starts with | The data fields value starts with the filtered value |
In List | Filters entities based on a list of filtered value |
Not in List | Filters entities based on if they are not in a list of filtered values |
Does not Contain | The data field's value does not contain the filtered value |
Does not End With | The data field's value does not end with the filtered value |
Does not Start With | The data field's value does not start with the filtered value |
is False | The data field's value is False |
Is True | The data field's value is True |
Greater than | The data field's value is greater than the filtered value |
Greater than or Equal to | The data field's value is greater than or equal to the filtered value |
Less than | The data field's value is less than the filtered value |
Less than or Equal to | The data field's value is less than or equal to the filtered value |
Older than Timespan | A dateTime field is older than the specified timespan |
Within Timespan | A dateTime field falls within the specified timespan |
Younger than Timespan | A dateTime field is younger than the specified timespan |
Today | The dateTime field is equal to the current date |
Tomorrow | The dateTime field is equal to tomorrow's date |
Yesterday | The dateTime field is equal to yesterday's date |
Last Week | The dateTime field falls into last week's date range |
This Week | The dateTime field falls into this week's date range |
Next Week | The dateTime field falls into next week's date range |
Last Month | The dateTime field falls into last month's date range |
This Month | The dateTime field falls into the current month's date range |
Next Month | Filters entities based on if the dateTime field falls into next month's date range |
Last Year | The dateTime field falls into last year's date range |
This Year | The dateTime field falls into the current year's date range |
Next Year | The dateTime field falls into next year's date range |
Before Days Filter | The dateTime field occurs before X number of days |
After Days Filter | The dateTime field occurs after X number of days |
Folder Filters | Function |
---|---|
For Current Folder | Filters entities based on if they exist for the current folder the Report is located in |
For Current Folder and Subfolders | Filters entities based on if they exist in the current folder and subfolder the Report is located in |
For Current Subfolders | Filters entities based on if they exist in the subfolders the Report is located in |
For Folder | Filters entities based on if they exist in a specified folder |
For Folders and Subfolders | The entities exist in a specified folder or its subfolders |
For Parent Folder | The entities exist in the chosen Parent folder for the folder the Report is located in |
For Subfolders | Filters based on if entities exist in subfolders for the specified folder |
In missing Folders | Filters if entities exist or are missing from certain folders |
Infrastructure Filters | Function |
---|---|
And | Provides a way for a user to specify the entity needs to match both filter criteria to be displayed on the Report |
Or | Provides a way for a user to specify the entity needs to match at least one of the filter criteria to be displayed on the Report |
SQL Based Filters | Function |
---|---|
Current Folder Filter | Provides a way to specify a filter for the Report based on specific fields of the folder. |
Current User Filter | Provides a way to specify a filter for the Report based on the current user. |
Additional Filters | Function |
---|---|
Date Range Filter | Provides a way to filter a Report by specifying a date range for a dateTime field of an entity. |
Respect Permissions | Provides a way to filter the Report based on if the current user has the below permissions for the entity |
Rule Filter | Allows the user to create a custom Rule filter on a Report. |
Feature Changes
Description | Version | Release | Developer Task |
---|---|---|---|
Added the "Contains in List" filter. | 9.7 | February 2025 | [DT-042483] |
Was this article helpful?