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
  
  With this filter you can define a schedule.

Template

Select template to use for displaying the filter. By default we use the same template as the filtertype. If you do not specify a template the filter will not appear!

Internal Filtername

Define an internal name for the filter. You need this internal filtername if you define dependencies on filters. 

Filter Title

This is the filtername as it appears in the filter dialog.

Attribute to Filter on

Define the name of the attribute you want to define a filter on. If you do not know the name of the attribute please refer to fields and alias.

Fields and Aliases - SKyPRO Products - Collaboration

Value to Filter the Attribute

Leave it blank!

Querystring

Enter a querystring if you want to make a preselection of all attribute values that are available in the filter. e.g. In a user report you only want to select users that are in a subcontainers of ou=users,o=data, you can enter the following query in a filter of the attribute parent:

This querystring will prefilter to show only containers in subtree ou=users,o=data where objects of objectclass inetOrgPerson reside. Therefore this filter will only present the containers shown below. Nevertheless there are some more subcontainers in ou=users,o=data, but these containers do not hold any object of objectclass inetOrgPerson.

Query keyattribute

Add the same attribute name as in field Attribute to Filter on.

Query Valueattribute

Add the same attribute name as in field Attribute to Filter on.

Make Unique Values

Check this box in most cases. If there are multiple similar values for the selected attribute, it only shows the value once.

e.g. If you define a filter on givenName and you have multiple users with the same givenName, the givenName will only appear once.

Make Unique Values checked:

Make Unique Values unchecked:

Sort direction

How do you want to sort the filter values that appear in the filter, asc=ascending, desc=descending

e.g. givenName filter sorted descending.

List of Filter we depend on

You can make filters dependend on other filters.

BUT: Only select filters you can make dependent on other select filters!

e.g. for your user report you only want to be able select users from subcontainers ou=users,o=data. You define a filter on attribute parent as described above in querystring definition. Subsequent filters like lastname (sn) and givenName you want to make dependend on what you select in the parent filter. You only want to show lastnames and givenNames of users in the container you have selected in the parent filter. In that case you have to make the filters on attribute sn and givenName dependent on the filter defined for the attribute parent.

Below you see the filter on attribute parent, named f_parent with the appropriate querystring:

In the filter definition of sn and givenName you add the filter f_parent to make these filters dependend on the f_parent filter

The result is as you click on a specific container in the parent filter the available values in the dependend filters sn and givenName show different values. Only sn and givenName that are available in the selected container.

If you select container ou=IG

If you select container ou=KSSG

If you select container ou=custom

If you select ou=extern

You can even cascade the filter dependencies. So you can make the filter on givenName (Firstname) dependend on what you select on filter sn (Lastname). So if you select a specific lastname only firstnames will be shown of users that have the selected lastname.

To reach this goal make filter givenName (internal filtername e.g. f_givenName) dependend on filter surname (using the internal filtername e.g. f_sn) AND on parent filter (f_parent)

The result will look like this if you select e.g. "Meier" as lastname. There are three users with lastname "Meier": "Stafan Meier", "Max Meier" and "Franz Meier"

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!