Filtering reports
When you run or download a report, you can choose to include only records that relate to a specific time period or choose records that contain specific sample information or data. You do this by selecting a filter to apply to the report.
When installed, the Interviewing activity includes several different filters, which you can amend to suit your own requirements. You can also add your own filters, or delete filters that you no longer want. You define a filter by writing a filter expression.
Note that you cannot amend or delete the “Other” and “No limit” filters installed with the Interviewing activity. In addition, the Appointments Summary report ignores any filter that you have selected, and the cross project reports ignore datetime filters.
To add a date filter
1 From the Tools menu, choose Set Filters. This opens the Set Filters dialog box.
2 Select the Date Filter tab.
3 In Name, enter the name of your new filter. The maximum filter name length is 128 characters.
4 In
Filter expression, enter the expression for your new filter. The maximum filter expression length is 512 characters. For more information, see
To write a filter expression.
5 Click Add, and then click OK.
Note An alternative for adding either a date or sample filter is using the Copy button. This will copy the selected filter, allowing you to rename the filter and edit the syntax.
To edit a date filter
1 From the Tools menu, choose Set Filters. This opens the Set Filters dialog box.
2 Select the Date Filter tab.
3 In Filters, select the filter you want to edit and click Edit.
5 Click OK.
To delete a filter
1 From the Tools menu, choose Set Filters. This opens the Set Filters dialog box.
2 Select the Date Filter tab.
3 In Filters, select the filter you want to delete and click Delete. This opens a confirmation dialog box.
4 Click OK. This removes the filter from the list of filters.
To add a sample filter
1 From the Tools menu, choose Set Filters. This opens the Set Filters dialog box.
2 Select the Sample Filter tab.
3 In Name, enter the name of your new filter. The maximum filter name length is 128 characters.
4 In
Filter expression, enter the expression for your new filter. The maximum filter expression length is 512 characters. For more information, see
To write a filter expression.
5 Click Add, and then click OK.
Note An alternative for adding either a date or sample filter is using the Copy button. This will copy the selected filter, allowing you to rename the filter and edit the syntax.
To edit a sample filter
1 From the Tools menu, choose Set Filters. This opens the Set Filters dialog box.
2 Select the Sample Filter tab.
3 In Filters, select the filter you want to edit and click Edit.
5 Click OK.
To delete a sample filter
1 From the Tools menu, choose Set Filters. This opens the Set Filters dialog box.
2 Select the Sample Filter tab.
3 In Filters, select the filter you want to delete and click Delete.
To write a filter expression
The expression text that you use in filter expressions must be supported by the UNICOM Intelligence Data Model and can include functions from the UNICOM Intelligence Function Library. For more information, search for “Expression evaulation” in the UNICOM Intelligence Developer Documentation Library.
See also