TeamCompanion v6.0 brings easier filtering while viewing work item query results. Each column in the grid now includes a built in dynamic filter that allows you to quickly filter your view based on values from one or more columns.
TeamCompanion supports full text search over all work item fields as well as advanced work item field search conditions since its earliest version. The newest version v6.0 introduces dynamic filtering on the level of each column in the work item query results grid.
Excel Like Column Level Filtering
In the right corner of each grid column header there is an arrow button used to access the filter for that particular column. Filter dropdown lists are dynamically populated with unique values from respective columns. The following picture shows filters for 2 columns in a sample sprint backlog query result list.
To apply a particular filtering value, click on it in the filter dropdown. The query result list will be filtered based on this value and will show a subset of work items that meet the filter criteria.
The following picture shows how the above sample sprint backlog query result list looks after applying the filter [Work item Type] = ‘Task’. The arrow in the column header has changed the color to black, indicating that a filter is applied on that column. Additionally, a status bar appears at the bottom of the list, displaying the value of the current filter.
You can filter by more than one column. Filters are additive, which means that each additional filter is based on the current filter and further reduces the subset of work items displayed in the list.
The following picture shows how our sample sprint backlog query result list looks like after applying two filters: [Work item Type] = ‘Task’ and [Assigned To] = ‘Cameron Skinner’.
The status bar on the bottom of the list displays the value for the current filter. You can access the list of all recently used filters by clicking on the dropdown arrow next to the filter. To apply one of the previous filters, just click on it in this list. To clear the current filter, uncheck the filter checkbox in the status bar. To close the status bar, click on the button x.
Once you have filtered data in the work item query result list, you can either reapply another filter or clear all filters to redisplay all work items originally included in the result of the query you were filtering.
The Reset View action on the Work Item(s)/Query ribbon or in the query’s context menu in Navigation Pane) will remove all filters applied and reset the query to the version previously saved on TFS.
Special, Custom and Advanced Filtering Options
Each column can be filtered by two distinctive predefined values: (Blanks) and (Non blanks). The following picture shows the list after the filter [Remaining Work] is Null has been applied.
To create a custom filter for a particular column, click on the value (Custom) in the column’s filter dropdown and set your conditions.
For example, if you want to filter out work items with Remaining Work values between 4 and 10, you can use the filter shown on the following picture.
If you click on the Edit Filter button that appears right in the status bar on the bottom of the list, the advanced Filter Editor dialog is displayed. There you can combine multiple filtering options using advanced criteria.
Searching in Filtered Lists
When you use the full text search or advanced work item field search conditions to search filtered work items, only work items that are currently displayed are searched; work items that are not displayed are not searched. To search all the data, first clear all filters.
The following picture shows the results of searching by [Assigned To] = ‘Brian Keller’ on the sample sprint backlog list when no filters were previously applied, and when the filter [Work item Type] = ‘Task’ was previously applied on the list.
Dynamic Column Level Filtering Will Enhance Your Productivity
We believe that this new feature will further enhance your productivity on a daily basis.
Dynamic filtering on the level of each column in the work item query results grid will allow you to quickly locate the data you are actually searching for, without the need to manually author filters. If you still need more advanced searches, you can always use the standard and advanced TeamCompanion's searching and filtering capabilities.