Configuring Responder/Smart Grid
Sorting Order

Version: 10.1

Resource Center Home

You can change the sorting settings for the following reports:

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

  1. Open ArchiveQueriesConfig.xml. By default, this file is installed here: C:\Program Files (x86)\Miner and Miner\Responder\Server.
  2. 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.

  1. Search for the appropriate reports to edit. Report names are found in the the Caption attribute. 
    Note: Each report appears twice in ArchiveQueriesConfig.xml - once for the Category of Browser and once for Excel.
  2. Replace the Value attribute of the SortingOrder with either Ascending or Descending.
  3. Repeat these steps for the same report with a Category attribute of Excel.
  4. Save and close ArchiveQueriesConfig.xml. There is no need to edit ArchiveSchemaConfig.xml for this configuration.
  5. Close and reopen Responder Archive Explorer to view the updated changes.


Send Comment to documentation@schneider-electric.com