Report Filter Overview
  • 10 Feb 2022
  • 4 Minutes to read
  • Dark
    Light

Report Filter Overview

  • Dark
    Light

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 on how to create a rule filter.

Report Filter list

Entity FiltersFunction
ArchivedFilters entities based on the is_archived field 
Created by meFilters entities based on if they are created by the current user
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 entities based on their state
Text SearchFilters entities based on a text search on the Name and Description fields
Field FiltersFunction
Does not EqualFilters entities based on if the data field's value does not equal the filtered value
ContainsFilters entities based on if the data field's value contains the filtered value
Ends WithFilters entities based on if the data field's value ends with the filtered value
EqualsFilters entities based on if the data field's value equals the filtered value
Not EmptyFilters entities based on if the data field's value is not empty
EmptyFilters entities based on the data field's value is empty
Starts withFilters entities based on if the 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 ContainFilters entities based on if the data field's value does not contain the filtered value
Does not End WithFilters entities based on if the data field's value does not end with the filtered value
Does not Start WithFilters entities based on if the data field's value does not start with the filtered value
is FalseFilters entities based on if the data field's value is False
Is TrueFilters entities based on if the data field's value is true
Greater thanFilters entities based on if the data field's value is greater than the filtered value
Greater than or Equal toFilters entities based on if the data field's value is greater than or equal to the filtered value
Less thanFilters entities based on if the data field's value is less than the filtered value
Less than or Equal toFilters entities based on if the data field's value is less than or equal to the filtered value
Older than TimespanFilters entities based on if a dateTime field is older than the specified timespan
Within TimespanFilters entities based on if a dateTime field falls within the specified timespan
Younger than TimespanFilters entities based on if a dateTime field is younger than the specified timespan
TodayFilters entities based on if the dateTime field is equal to the current date
TomorrowFilters entities based on if the dateTime field is equal to tomorrow's date
YesterdayFilters entities based on if the dateTime field is equal to yesterday's date
Last WeekFilters entities based on if the dateTime field falls into last week's date range
This WeekFilters entities based on if the dateTime field falls into this week's date range
Next WeekFilters entities based on if the dateTime field falls into next week's date range
Last MonthFilters entities based on if the dateTime field falls into last month's date range
This Month Filters entities based on if 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 YearFilters entities based on if the dateTime field falls into last year's date range
This YearFilters entities based on if the dateTime field falls into the current year's date range
Next YearFilters entities based on if the dateTime field falls into next year's date range
Before Days FilterFilters entities based on if the dataTime field occurs before X number of days
After Days FilterFilters entities based on if the dataTime 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's 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 Folder and SubfoldersFilters entities based on if they exist in a specified folder or its subfolders
For Parent FolderFilters entities based on if they exist in the Parent folder for the folder the Report is located in
For SubfoldersFilters entities based on if they exist in subfolders for the specified folder
In missing FoldersFilters entities based on if they 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 in order 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 in order to be displayed on the report
SQL Based FiltersFunction
Current Folder FilterProvides a way to specify a filter to the report based on specific fields of the folder.
Current User FilterProvides a way to specify a filter to 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



Was this article helpful?