Filter List
Filter Lists feature allows the user to define a set of filters and respective filter values and save them as a filter list so that they can later be used to provide filter values at runtime.
The saved filter lists are shown on the report submit screen. Selecting any filter list will populate the filters in the run screen of reports with the filter values saved in the filter list that match by the filter name.
This feature reduces the time to select the filter values every time any report is submitted by fetching the values from a predefined list.
There are several ways to create a filters list as given below.
Configurations Screen
Navigation:Reports-Filters List
Actions that can be performed from Filters List configuration screens
- Create Filter List
When user clicks on create button following page is displayed further to add filters.
Creating filters
When user clicks on create filter button following page is displayed.
User can select the values for the filter by providing the LOV name or directly give the filter values.
When LOV Source is selected as LOV name, user can further select LOV as shown below.
On Click of Values search following lov values popup is shown below.
When LOV Source is set to Query, user can select a connector and query to execute and select values for the filters from the output of the query.
When LOV Source is set to None, user can provide constant values or provide a query that will be execute when the filter list is applied to a report/report set/chart/dashboard.
Based on the nature of the filter values user can select a data type. Here user is allowed to choose from following data types.
- Text
- Number
- Date
- DateTime
For Date type data types user can provide range type date values as below.
Creating filters through import filters
Filters can also be imported from the reports shown in the below screen shot. Only one object can be selected at once to import the filters from that object
When user clicks on import filters following page is displayed with reports based on access.
Save Filter List
On click of save icon following page is displayed to enter a name for filter list,code and description.
Enabled switch when set to off, filters list is treated as disabled and user cannot use them on run pages.
Assigning filter list to objects
Us User can assign the filter list to report/domain/report set as below. There are multiple ways to navigate to assignment screen
From
Filter list home page
Fro From multi select section on homepage
From fi FilterList edit screen
From From all above navigations following page is displayed.
Whe When a filter list is assigned to a domain, it gets assigned to all the objects from the domain.
Shar
Filter list
There There are multiple ways to navigate to share page.
From
filter From Filter list home page
Fro From multi selection section on home page
From f From Filter list edit screen
From From all above navigations following page is displayed.
Whe When user chooses public and save, filter list shared to all users. When it is private user needs to choose the entity filter list needs to share with.
Filter Filter List Info screen
User User Can navigate to view filter list info from filter list home page
Filter Filter list usage data and share data are shown on info screen as below
