/
mi2b2 User Documentation - Sorting and Filtering

mi2b2 User Documentation - Sorting and Filtering

Jun 09, 2014

Overview

Most of the data are shown in tables in the mib2 client. These tables support sorting and filtering. Here we use the Request Management UI (Tab 3) as an example to show how users can sort and filter tabular data.

Video

Requires Flash Player


(video length: 1:55)

This video demonstrates mi2b2's sorting and filtering features. Learn how to

  1. Sort table data in ascending, descending, or original order.
  2. Access the filter controls.
  3. Use the check box controls and the range slider controls to perform filter.
  4. Issue complex queries involving multiple columns.

Please note that the video is based on mi2b2 1.2.00. Text-based filters have been introduced in 1.3.0. Please read below for their introduction and how to use them.

Sorting

In general, users can click on the header of each column to sort the rows by that column. The first click will sort the column in ascending order, the second click results in descending order, and the third click results in the original order, resetting sort. For example, sorting by Request ID (the 1st column) in Tab three resembles the following screenshots. Note the a a sorting arrow in the highlighted column header for "Request ID" for each of the ascending and descending sorts.

Original Order

Ascending Order by Request ID

Descending Order by Request ID

Users can apply sorting to to all data in the table" dates (such as Study Date), texts (Modalities, Comments, MRNs Request ID's), time (Download Time Remaining), file size, etc.

The one place where sorting is limited is in Tab 1. The table in Tab 1 is actually a tree structure to support displaying patients that have the same MRN. A tree is not amenable to sorting on all columns like tables are. Instead, users can only sort the patients by their MRN.

Filtering

In the tables in Tab 1 (Searching Patient by MRNs), 2 (Search Studies by ANs), 3 (Viewing and Managing Requests), and 5 (Managing Remote Cache), users also have the option to filter the rows. The only table that is not filterable is the Download Manager in Tab 4. We use Tab 3 to illustrate the filter functionality.

By selecting the "Show Filter" button in each of Tab 1, 2, 3, and 5, users can access the filter widgets. Press the same button again (now "Hide Filters"), users can hide them.

The mechanics filtering is simple. There is a set of widgets corresponding to each column of the table. By appropriately selecting only the values users want to see in that column, the filter will automatically hide the rest. For example, if users want to see only "Magnetic Resonance", they would select only "Magnetic Resonance" in the filter widget corresponding to the column "Modality". If the users want to see studies that either "Magnetic Resonance" or "Computed Tomography", users would then have those two selected in the widgets.

Checkboxes Filter

Range Slider Filter

Text Box Filter

 

Combining filters

Filter Reset

The filters are reset whenever the table is refreshed with new data. This occurs when, for example, users searched for a new MRN in Tab 1, searched for a new AN in Tab 2, or pressed "Refresh" in Tab 3 or Tab 5. Any previously set filters will be reset, and no filter will be applied to the new data. Users must re-apply the filters.