Filter (definitions)

Filter definitions let you filter the data for your report. BUT there are two completely differnet type of filters, that have a different purpose:

• select filters 
• hidden filters

Select Filters

Select filters are filters, that are displaied when generating a report, to select specific objects you want to put on your report.

Select filter types are:

• search
• select
• selectsearch
• selectperiod
• selectrange

Select filters are shown in the filter selection when generating the report.

For a filter definition you have a lot of options available. Here only the most important options will be explained

Filtertype

Select type of filter you want to use. There are 5 different filtertypes:

• search
  
  Enter a search string you want to select a specific attribute value. You have to enter the exact value. Substring does not work. It makes most sense for 1-5 character filters. e.g. for employee type like i=internal, e=external, p=partner etc,
  
  
• select
  
  A select box displayes all available values of the attribute. You can select no or as many value(s) from the list as you like.
  
  
• selectsearch
  
  A select box displayes all available values of the attribute. At the top you have a search box to search for specific values. Substring search das work. You can select no or as many value(s) from the list as you like.
  
  
• selectperiod
  
  For date/time fields to select a period. A date/time range select box will appear as soon as you 
  
  
• selectrange

Template

Select template to use for displaying the filter. By default we use the same template as the filtertype.

Internal Filtername

Filter Title

Attribute to Filter on

Value to Filter the Attribute

Querystring

Query keyattribute

Query Valueattribute

Make Unique Values

Make Unique Keys

Sort direction

List of Filter we depend on

Only select filters you can make dependent on other select filters.

Hidden Filters

Hidden filters do not show up in the filter selection when generating the report. So hidden filters have NO EFFECT on select filters even if you make select filters dependend on hidden filters!