Koha How-To

Monday Minutes: Using the Reports Plus Plugin

In this week's Monday Minutes, Jessie and Kelly show you how to use the Reports Plus Plugin in Koha. This plugin allows the use of lists to be input into reports. This plugin can enhance staff workflow when you wish to run a report on a set of barcodes, biblionumbers, itemnumbers, etc.

Installing the Plugin

The Koha Plugin for Reports Plus can be found on GitHub at https://github.com/bywatersolutions/koha-plugin-reports-plus.

You can find more information on plugins, including uploading a new one, through our tutorials!

Using Reports Plus

Once the Plugin is installed you can walk through the steps below to use the integrated features of Reports Plus.

  1. Create a report in the Koha reports module.
  2. To utilize the list functionality the report syntax should include a value of (<<List parameter>>).
    1. example: WHERE barcode in ( <<Barcodes>> )
  3. Return to the plugins in Administration --> Plugins.
  4. Under the Reports Plus Plugin click Actions --> Run the plugin.
  5. Enter the report number from the report you created above.
  6. The plugin scans the report for parameters and asks you for the type of each, you can choose:
    1. Date
    2. List
    3. Text
  7. The next step will ask you for values:
    1. example: barcodes, ISBN, itemnumbers
  8. All parameters must be filled.
  9. You may choose how the results are outputted, display on the page, or export as a CSV.
  10. Click Run Report.

Example Report

SELECT biblio.biblionumber, items.itemcallnumber as 'call#', biblio.title, items.location, items.itype, items.barcode

FROM items

LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)

LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)

WHERE barcode in ( <<Barcodes>> )

ORDER BY items.location asc