Output Display and Sorting
The Output Settings section of the Alarm Query dialog box is separated into five sections.
Output Range
Click in the Output Range field and select a range of cells in a single row or column to determine where the returned data is placed.
Output Orientation
Select either Columns or Rows for the output display. Selecting Columns displays a table of values with parameters arranged in columns with header labels at the top. Selecting Rows rotates the table 90 degrees.
Maximum Results
Enter a maximum number of results for the query to return
Output Display
The Output Display section specifies which attributes the Excel Add-In should return to the spreadsheet. Multiple selections can be made by holding the CTRL key and selecting.
Output Sorting
Before displaying the returned alarm and event data in your Excel spreadsheet, the Excel Add-In can sort the values according to the criteria you specify in the Output Sorting section. The following table describes how the different sorting options sorts values:
| Sorting Options | Values Displayed |
|---|---|
| Alarm Time | Sorts the returned alarms or events by the alarm or event's Start Time attribute. The results will be sorted in descending order. |
| Custom Sort | Allows you to select which field(s) to sort the returned alarms and events by. You can also specify whether to sort in ascending or descending order. Multiple sort conditions are supported. |
| None | The returned alarms and events are not sorted at all. They will be returned in the order they are received from the alarm and event database. |