Many EMS functional areas use a Browser window. For example, the Groups window, the Query Builder window, and the Service Order Management window are all EMS Browser windows. You use an EMS Browser window to search for data, add new data, and edit and/or delete existing data. For example, in the Groups Browser window, you can search for groups or contacts, add new groups or contacts, and edit or delete existing groups or contacts. Regardless of the EMS functional area, all EMS Browser windows have the following features in common:
• The click and drag feature enables you use to group data by a specific column, rearrange the order of the data columns, or change the width of a column. This feature is always indicated by the option to drag and group by a column header at the top of an EMS Browser window. If a window/window pane does not display this option, then the window/window pane is not an EMS Browser window.
• A column context menu that has a multitude of options for sorting data, grouping data, sizing columns and so on.
• A filtering feature that you can use to find and work with a subset of data in the window.
• A column sorting feature that you can use to sort data by a specific column.
Note: These procedures are explained using the Groups window; however, the instructions are applicable for any Browser window in EMS.
In any browser window, you can drag a column header to the indicated location and group the data by the selected column. You can drag multiple column headers to the location. If you sort data by multiple columns, then the first column is the parent column. All other columns are placed as child columns, and the data is grouped accordingly in the browser window.
You can rearrange column order by dragging a column to a new location using the column heading.
Changing column width
You can change column width by resting the mouse pointer on the right side of a column heading until the pointer changes to a double-headed arrow, and then dragging the boundary.
Using the context menu
Right-click in any column in a browser window to open a context menu that has a multitude of options for sorting data, grouping data, sizing columns, and so on.
1. Open a browser window, for example, the Groups window.
2. Place your cursor in the data column by which you want to filter the data. For example, to filter data based on the City for group records, place your cursor in the City column. A Filter icon is displayed in the column.
3. Click Filter to open a list of filter options, and then select the appropriate option for creating the filter.
Tip: Any filter you create is always displayed in the bottom left corner of the browser window.
Opens the Custom AutoFilter dialog box in which you can construct a custom data filter.
Filters data based on NULL (blank) data for a field. For example, if you click on Blanks in the City column in the Groups window, then all group records for which the City field has a NULL (blank) value are displayed in the Groups window.
Filters data based on Not Null (not blank) data for a field. For example, if you click Non blanks in the City column in the Groups window, then all group records for which the City field does not have a NULL (blank) value are displayed in the Groups window.
<Specific Data Value>
A Filter list also displays each unique value that has been entered for the field. Select a value on this list to filter the data by the value. For example, select “Denver” in the City column of the Groups window to display only those group records that have “Denver” specified as the group’s city.
4. To edit the current filter, you can click Edit Filter in the lower right corner to open the Filter Editor dialog box.
• To add a new condition to a filter, click Add/Insert.
• To remove a condition from a filter, click Delete at the end of the filter.
• To apply a new filter, click Apply.
• To close the Edit Filter dialog box and return to the browser window, click OK.
Changing the sort order of data
When a browser window first opens, data are sorted in ascending order based on the data in the first column of the window. For example, when the Groups window first opens, the group records are displayed on the Results tab alphabetically by Group name. To change the sort order of the data in a browser window:
1. Click once in any column header to display a Sort Order icon; an “up” arrow indicates that data is sorted in ascending order.
2. Click the up arrow to sort data in descending order.
3. Click the down arrow to sort data in ascending order.