...
| Section |
|---|
| Column |
|---|
| 
(video length: 1:55)
|
| Column |
|---|
This video demonstrates mi2b2's sorting and filtering features. Learn how to - Sort table data in ascending, descending, or original order.
- Access the filter controls.
- Use the check box controls and the range slider controls to perform filter.
- 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.
| Section |
|---|
| Column |
|---|
| Original Order
|
|
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.
...
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.
...
| Section |
|---|
| Column |
|---|
|
| Column |
|---|
There are two three types of filter widgets in mi2b2 client. The first type of filter widgets is a group of checkboxes (left and 1 in the full screenshot above). mi2b2 will filter out any checkbox that is not selected. By default, all checkboxes are selected (nothing is filtered). |
|
...
| Section |
|---|
| Column |
|---|
|
| Column |
|---|
The second type is a the range slider (left and 2, 3 in the full screenshot above). It is a scroll bar with two end points that users can move independently. The values between (and including) the two endpoints are the values that users select, and the rest are filtered out. This type of filter is useful for values that can be meaningfully ordered, such as dates (3), or have many values (2). By default, a Range Slider range slider selects all values in the table (nothing is filtered). The lower end point (minimum) and the upper end point (maximum) values are always displayed. The filter action takes place when users release the dragging action of the end point controls. Once a range is set, users can also drag the range thumb to move both the upper and lower end point controls simultaneously. Double clicking on the yellow portion of the range slider resets it. |
|
Text Box Filter
| Section |
|---|
| Column |
|---|
(1)  Image Added
(2)
 Image Added |
| Column |
|---|
The third type is the text box filter (left (1) ). It is a text box where users can freely enter any text, for example, a list of MRNs. After application, the filter will find items that matches any of the MRNs entered.Text filters are designed only for columns that contain MRNs or Accession Numbers (ANs). We will use MRN as an example, but the mechanics are exactly the same for ANs. To enter a list of MRNs , users will enter them in the box, separating each MRN by a comma (","), or a space (" "), or a new line (created by pressing "enter" or "return"). Empty lines are ignored. For example, in the figure to the left, (2) shows that the following list of MRNs "0002" "0070" "0110" "1234" and "2525" are correctly entered. After adding a list of MRNs, users need to press "Apply Filter" to apply the filter. If users wish to remove an existing text box filter, users will need to remove all text in the text box and then press "Apply Filter" to reset the filter to its no-filter default state. Tip: Users can user keyboard short cuts to select everything in the text box (ctrl-a in Windows and command-a in OSX), and then press "delete" or "backspace" to remove them. |
|
Combining filters
| Section |
|---|
| Column |
|---|
|
| Column |
|---|
Behind the scene, the filter for each column is then combined to filter the entire the table. Within each filter, the values are "OR'ed", while among filters, the values are "AND'ed". For example, the combined filter to the left means | Panel |
|---|
"Show me all study requests that have modalities of either Magnetic Resonance OR Computed Tomography. AND, in addition, show me only the requests that have been requested in the time period of 7/13/2011 14:01:40-07/15/2011 10:32:45." |
Users do not have to do anything to combine filters explicitly. The filters are always active. As soon as users click on a checkbox, or release an endpoint in the range slider, a new |
|
...
