22.05 - How to change the default sort order of the saved reports table

22.05 - How to change the default sort order of the saved reports table

This document will outline how to set the default sort order of the saved reports table by the preferred column. 
For more information on the saved reports table in general, please check our Help Centre or submit a ticket with any specific questions you have.

How the report table is sorted by default

The default sort order for a saved reports table will be a random selection:


How to change the default sort order

Go to Koha administration > Additional parameters > Table settings.


This will open a new page with a collapsed table of the different tables which contain columns that can be edited. 

Click on the Reports section.

This will dropout a selection of tables which can be used to change the functionality of columns on the different tables on Koha. 

Go to the table_reports table.


At the bottom of the table, there is a line called Default sort order.


Click the box to the right hand side of this line and a dropdown menu will appear. 


This dropdown menu will contain the different options for the columns to sort the table by. This example will use report_name as the sort order. This will mean the table will be sorted alphabetically by the name of the report. 

Click the preferred option to sort the table by. Click Save.

How the report table appears after resetting the default sort order




VersionDateDetailAuthor
1.022/12/22Document createdHolly Cooper




























    • Related Articles

    • How to change the default sort order on OPAC

      How to change the default sort order on the OPAC   When you search on OPAC and retrieve more than one result, you can change the order in which the results display by clicking on the dropdown option in the top right of the list, If you want to change ...
    • Placing an Order

      How to Place an Order   This document explains how to place an order.  To place an order you must first search for the vendor or bookseller you want to send the order to. Enter part of the vendor name and click submit or just click submit to list all ...
    • How to set a default value for a field

      Koha frameworks shape MARC21 into workforms of information library staff can use to create records for their catalogue. The fields in these workforms can be edited in a variety of ways through the associated framework. This document will outline how ...
    • How to re-arrange the order of subfields

      This document will outline how to move the order of subfield codes in a framework. By default, these subfields appear in ascending numeric and alphabetic order but can be manually rearranged  to appear in a particular pattern. If you require more ...
    • Cancelling an Order

      How to Cancel an Order This document explains how to cancel an order.  For the purposes of the example order 8 is being cancelled.  This number will change order-to-order on your live  system as transactions are processed.  Supplier sends ...