Understanding the grid

There are a number of functions common to almost all grids, wherever they occur in the system.

A good understanding of their many, powerful functions helps you to work quickly and to dynamically organise the grid's information according to your needs.

These grid functions include:

1. Add: create a new member of the list
2. Duplicate this member of the list
3. Delete this member of the list
4. Save changes to this member of the list
5. Print the list
6. Export the list to Excel: creates and downloads an Excel document containing the information in the grid cells.

This enables you to use Excel’s Macros and to create ad hoc reports on your information.

7. Refresh the list with the latest information
8. Filter the list

On some grids you will also see:

9. Undo

Most of these options are fairly self-explanatory and are best seen in context.

The quick filter allows simple filtering based on the values in the grid columns.

1. Click the grid filter icon to open a filter area at the top of each column.
2. Click the column filter icon and select the kind of filter you want to use in this column.
3. Enter text in the filter box.

As you type, those cases that match the filter specification are displayed in a dropdown list so that you can make a quick selection :

After you click anywhere else on the screen, the Case List will only shows the cases that match these filter specifications.

This feature allows you to collect the Case List into groups based on column values.

Drag and drop a column heading into the Group By bar to group the cases by that column type.

1. The screenshot shows the result of dragging the Assign to - Name column heading.
2. Click the triangle icon to view the cases nested under the value of that column heading.

To un-group the cases, drag and drop the column header back to the other column headers or simply click its x icon.

The Case List Criteria applies only to the Case List grid.

After you click the icon, a window displays with three tabs:

1. The Filter tab provides filtering options based on case values which may not be displayed in the grid, such as employee assignments.

The filters specified here are the 'master' set of filters. You can filter within their results using the grid filter described above.

2. The Columns tab specifies which case fields feature as columns in the grid. It is shown below. The fields available are nested in a tree structure in order to provide access to all case information. This makes the grid completely customisable.
3. The Save tab enables you to save particular views of the Case List (columns and filters), so that you can come back later and apply them without having to reselect everything again.

The video demonstrates standard grid functions that apply to most grids in Case Manager.

It also shows the extra Grid functions at the 'master' grid, i.e. the Case List, using the Case List Criteria.

The video shows grids in the Windows version of Case Manager, however the concepts are the same.