Sorting Order

You can change the sorting settings for the following reports:

Reliability Indices: SAIDI by Cause Code
Minutes and Outage Count by Cause Code

To select if the sort by column in these reports sorts ascending or descending:

Open ArchiveQueriesConfig.xml. By default, this file is installed here: C:\Program Files (x86)\Miner and Miner\Responder\Server.

Look for the following XML.

<QueryClass Key="SaidiByCauseCode" Caption="Reliability Indices: SAIDI by Cause Code" Category="Browser">
        <Properties>
         <b:Property Key="Description" Value="A tabular report of SAIDI by Cause Code." />
         <b:Property Key="TimePeriod" Value="MTD" />
         <b:Property Key="Tmi" Value="5" />
         <!--<b:Property Key="IncidentCauseCodesToExclude" Value="6,10" />
         <b:Property Key="ExcludeZeroSaidi" Value="true" />-->
         <b:Property Key="IncludeMajorEventDays" Value="true" />
         <b:Property Key="SortBy" Value="SAIDI" />
         <b:Property Key="SortingOrder" Value="Descending" />

The above XML indicates the Reliability Indices: SAIDI by Cause Code report sorts the SAIDI column in Descending order. Change the Value attribute for the SortingOrder property to select either Ascending or Descending.

Search for the appropriate reports to edit. Report names are found in the Caption attribute.

TIP: Making changes to any Archive Explorer report that has a QueryClass Category="Browser" will modify that same report in Responder Web.
Additionally, each report appears twice in ArchiveQueriesConfig.xml - once for the Category of Browser and once for Excel.
Replace the Value attribute of the SortingOrder with either Ascending or Descending.
Repeat these steps for the same report with a Category attribute of Excel.
Save and close ArchiveQueriesConfig.xml. There is no need to edit ArchiveSchemaConfig.xml for this configuration.
Close and reopen Responder Archive Explorer to view the updated changes.