Report Filter Glossary
  • 04 Feb 2025
  • 4 Minutes to read
  • Dark
    Light

Report Filter Glossary

  • Dark
    Light

Article summary

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 FiltersFunction
ArchivedFilters entities based on the is_archived field 
Created by meThe current user created the entity
Created within X daysFilters entities based on if they were created within X amount of days
Edited within X daysFilters entities based on if they were edited within X amount of days
HiddenFilters entities based on if the Hidden field for the entity is true
Limit to X EntitiesLimits the number of entities to be displayed on the Report
Modified by meFilters entities based on if they were last modified by the current user
Not in FolderFilters entities based on if they exist are not found in the same folder as the Report.
Recently CreatedFilters entities based on if they were recently created. Can set the count of recently created entities to display
State FilterFilters based on a chosen state
Text SearchFilters entities based on a text search on the Name and Description fields
Field FiltersFunction
[Field Name] FilterThis 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 EqualThe data field's value does not equal the filtered value.
ContainsThe data field's value contains the filtered value
Contains in ListA value exists within a specified list.
Ends WithThe data field's value ends with the filtered value
EqualsThe data field's value equals the filtered value
Not EmptyThe data field's value is not empty, i.e., it contains any value.
EmptyThe data field's value are empty
Starts withThe data fields value starts with the filtered value
In ListFilters entities based on a list of filtered value
Not in ListFilters entities based on if they are not in a list of filtered values
Does not ContainThe data field's value does not contain the filtered value
Does not End WithThe data field's value does not end with the filtered value
Does not Start WithThe data field's value does not start with the filtered value
is FalseThe data field's value is False
Is TrueThe data field's value is True
Greater thanThe data field's value is greater than the filtered value
Greater than or Equal toThe data field's value is greater than or equal to the filtered value
Less thanThe data field's value is less than the filtered value
Less than or Equal toThe data field's value is less than or equal to the filtered value
Older than TimespanA dateTime field is older than the specified timespan
Within TimespanA dateTime field falls within the specified timespan
Younger than TimespanA dateTime field is younger than the specified timespan
TodayThe dateTime field is equal to the current date
TomorrowThe dateTime field is equal to tomorrow's date
YesterdayThe dateTime field is equal to yesterday's date
Last WeekThe dateTime field falls into last week's date range
This WeekThe dateTime field falls into this week's date range
Next WeekThe dateTime field falls into next week's date range
Last MonthThe dateTime field falls into last month's date range
This Month The dateTime field falls into the current month's date range
Next MonthFilters entities based on if the dateTime field falls into next month's date range
Last YearThe dateTime field falls into last year's date range
This YearThe dateTime field falls into the current year's date range
Next YearThe dateTime field falls into next year's date range
Before Days FilterThe dateTime field occurs before X number of days
After Days FilterThe dateTime field occurs after X number of days
Folder FiltersFunction
For Current FolderFilters entities based on if they exist for the current folder the Report is located in
For Current Folder and SubfoldersFilters entities based on if they exist in the current folder and subfolder the Report is located in
For Current SubfoldersFilters entities based on if they exist in the subfolders the Report is located in
For FolderFilters entities based on if they exist in a specified folder
For Folders and SubfoldersThe entities exist in a specified folder or its subfolders
For Parent FolderThe entities exist in the chosen Parent folder for the folder the Report is located in
For SubfoldersFilters based on if entities exist in subfolders for the specified folder
In missing FoldersFilters if entities exist or are missing from certain folders
Infrastructure FiltersFunction
AndProvides a way for a user to specify the entity needs to match both filter criteria to be displayed on the Report
OrProvides 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 FiltersFunction
Current Folder FilterProvides a way to specify a filter for the Report based on specific fields of the folder.
Current User FilterProvides a way to specify a filter for the Report based on the current user.
Additional FiltersFunction
Date Range FilterProvides a way to filter a Report by specifying a date range for a dateTime field of an entity.
Respect PermissionsProvides a way to filter the Report based on if the current user has the below permissions for the entity
Rule FilterAllows the user to create a custom Rule filter on a Report



Feature Changes

DescriptionVersionReleaseDeveloper Task
Added the "Contains in List" filter.9.7February 2025[DT-042483]

Was this article helpful?