Many of the CalAmp K-12 screens have columnar data. You can organize the columns and sort and filter the values as best fit your needs.
Sorting
To sort a column, click its heading. The first click will sort by ascending order (an up arrow will be displayed), and a second click will sort by descending order (a down arrow will be displayed).
In the following figures, Event is the sorted column.
Ascending:
Descending:
Filtering
To filter a column by value, follow these steps:
- Click the Filter icon (
) to the right of the column name.
A filter options box will appear and display all the values that are currently in the selected column. For example, the following figure shows the values available for the Event column.
- Uncheck Select All and check the boxes of just the values you want to see.
- Click Apply to set the filter.
will appear to the right of the column heading, which indicates that this is the column being filtered by.
You can also filter the data by certain specifications, by condition. To do so, follow these steps:
- In the Filter dialog box, click the By Condition tab.
- Under First Condition, click the Select Condition drop-down arrow and select the condition from the list.
The available conditions are as follows:
- Equals: Displays only values that match exactly the text you will type in the Enter Value field.
- Does Not Equal: Displays only values that do not exactly match the text you will type in the Enter Value field.
- Begins With: Displays only values whose text starts with the letters/numbers you will type in the Enter Value field.
- Ends With: Displays only values whose last few characters are the text you will type in the Enter Value field.
- Contains: Displays any value that has the text you will type in the Enter Value field somewhere within it (so "ignition" will return both Ignition On and Ignition Off values).
- Does Not Contain: Displays any value that does not have the Enter Value text anywhere within it.
Note: The options for date and time filters are different, as follows:
- Equals: Displays only values that match the date/time you will enter.
- Is Before: Displays only values before the date/time.
- Is After: Displays only values after the date/time.
- Equals: Displays only values that match the date/time you will enter.
- Equals: Displays only values that match exactly the text you will type in the Enter Value field.
- Type the text to include or exclude (depending on the condition you selected) in the Enter Value field.
Note: The filter is not case sensitive, so if you enter a value of "ignition off" for an Equals condition, for example, "Ignition Off" values will be displayed. - Optionally, you can select another condition from the second Select Condition drop-down list (under Additional Condition) and type its corresponding textual value in its Enter Value field.
Note: Leave the AND radio button between the two conditions selected if you want to see only data that meets both specifications; click OR if you want data that matches either condition. - Click Apply.
will appear to the right of the column heading, which indicates that this is the column being filtered by.
Reorganizing
On many grid screens, you can change the order in which the columns are displayed. To do so, follow these steps:
- Click and drag the heading of the column you'd like to appear in a different spot in the grid. Don't release yet!
- Drag the heading to your preferred location for the column.
In both places, the column heading will be grayed out, and a blue bar will appear to the left of the new position. For example, the following figure shows the Hardware screen's Yard column being moved from the fourth position to the third one.
- Release the mouse button when you have the column where you want it.
The column will be moved to the new spot.
Note: On several CalAmp K-12 screens, you can add or remove columns in addition to rearranging where they are onscreen. And you can save your new layout so that the screen will always appear according to your preferences. For details, go to Customizing the Grid Layout.