Chapter 3 The Tariscope program
3.5 Working with views
3.5.12 Management of the filters
Tariscope has a filter management system that allows you to view existing filters, edit, save them, and create new filters. Also Tariscope includes pre-set filters.
To manage filters, in the menu, select View → Filters. The Filters window appears as shown in Figure 3.5.32.
Figure 3.5.32
The Filters window contains a list of filters in a form of a tree, filter conditions of selected filter, toolbar and search box. In Figure 3.5.32 the Outgoing for CUCM filter is selected. Its filter conditions are displayed in the bottom part of the window.
The Built-in filter group contains a list of the most common filters. These filters are preinstalled in Tariscope. Click on the ‘+’ near the Built-in group. The window will be as shown in Figure 3.5.33.
Figure 3.5.33
We briefly describe these filters.
Call party unknown. This filter provides a selection of calls where a calling party is unknown for all call types. It can be useful to find extensions that are absent in the Tariscope database.
Called subscriber unknown. This filter provides a selection of calls where a called party is unknown. It can be useful when you analyze incoming calls to find extensions that are absent in the Tariscope database.
Caller subscriber unknown. This filter provides a selection of calls where a calling party is unknown.
Calls with project codes. This filter provides a selection of calls where project codes were applied.
Incoming calls. This filter provides a selection of all incoming calls.
Outgoing and transit calls. This filter provides a selection of all outgoing and transit calls.
Previous month calls. This filter provides a selection of all calls for the previous month.
This month calls. The filter provides a selection of all calls for the current month.
This week calls. The filter provides a selection of all calls for the current week.
Today calls. The filter provides a selection of all calls that were made today.
Very expansive calls. The filter provides a selection of all calls which have a cost more than 50 units where the unit is a unit of the national currency. You can change this value.
Zero cost calls. The filter provides a selection of all calls which have the zero cost.
You can apply these filters with any different filter conditions.
The Filters window has a toolbar that contains the following icons:
- Apply filter. The icon allows applying a selected filter to a current view.
- Apply Inverted filter. The icon allows applying an inverted filter. For example, you have selected the Zero cost calls filter and, clicking on this icon leads to applying the filter with NO operator. As a result, for this example all calls that have a cost more than null will be selected.
- Sync active filter document. The icon allows you to synchronize the active filter of the view with data in the Filter window.
- Refresh. The icon allows you to refresh data in the window.
- New. The icon allows you to create a new filter for calls, services or IP traffic using SQL queries.
- Edit. The icon provides editing a selected filter.
- Rename. The icon allows you to rename a selected filter.
- Delete. The icon allows you to delete a selected filter.
- Collapse all. The icon allows you to collapse all branch of the filter tree.
- Show all. The icon allows you to open all branch of the filter tree.
The filter table of the window contains the following columns:
- Name. Displays a filter name or group name.
- Modification date. Displays a date when a filter was modified.
- Used for view. Displays a type of a view for which a filter is applied.
- Filter. Displays the filter conditions.
The Tariscope users often need to find data for a specific time period. Table 3.8 contains a list of such filters.
Table 3.8
| Time period | Query |
| Current day | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'d',0) AND dbo.DateToInterval(GETDATE(),'d',0) |
| Yesterday | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'d',-1) AND dbo.DateToInterval(GETDATE(),'d',-1) |
| Current week | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'w',0) AND dbo.DateToInterval(GETDATE(),'w',0) |
| Previous week | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'w',-1) AND dbo.DateToInterval(GETDATE(),'w',-1) |
| Current month | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'m',0) AND dbo.DateToInterval(GETDATE(),'m',0) |
| Previous month | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'m',-1) AND dbo.DateToInterval(GETDATE(),'m',-1) |
| Current year | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'y',0) AND dbo.DateToInterval(GETDATE(),'y',0) |
| Previous year | CallDateTime BETWEEN dbo.DateFromInterval(GETDATE(),'y',-1) AND dbo.DateToInterval(GETDATE(),'y',-1) |
| Specific month | CallDateTime BETWEEN '20160801 00:00:00' AND '20160831 23:59:59' |
| Specific year | CallDateTime BETWEEN '20150101 00:00:00' AND '20151231 23:59:59' |
| Specific period | CallDateTime BETWEEN '20131024 16:09:10' AND '20131025 16:09:10' |
Texts of queries for specific time periods (Specific month, Specific year, Specific period) in Table 3.8 are specified with particular values, which are displayed in bold. When you use these queries with your filter conditions, replace these values to desired values.
