Example: Creating filter conditions for accounts

This example report lists users with accounts of type ITIMService.

Assume that you specified the following entities, attributes, and filters to create the report template:
  • Report columns: Account.Userid, ITIM.ServiceName
  • Filters: None
Because no JOIN filter is specified, if there are two users:
  • User1 with ITIMService1 and ITIMService2
  • User2 with ITIMService3
The result is:
Table 1. Filter report
User Service
User1 ITIMService1
User1 ITIMService2
User1 ITIMService3
User2 ITIMService1
User2 ITIMService2
User2 ITIMService3

This result is the Cartesian product of the two tables; it does not display the wanted results. To yield the appropriate result set, specify the appropriate JOIN condition to indicate the relationships between these two tables. The JOIN condition in this case is:

Account.Service = ITIM.DN
If you specify this filter, the result is:
Table 2. New filter report
User Service
User1 ITIMService1
User1 ITIMService2
User2 ITIMService3