How to Report on Star Ratings on the OPAC

If star rating are enabled on the OPAC, staff members may wish to view details about how the feature is being used. This document will provide a basic SQL report which can be used to identify star ratings on the site.

For information on how to enable star ratings, please check our Help Centre or contact Interleaf Technology directly.

Navigate to the report creation area

Go to Reports > Guided Reports > + Create from SQL.

Create the SQL report

The format of the basic report should be:

SELECT *
FROM ratings

Once the SQL has been placed in the SQL box, as in the above image, click Save report at the bottom of the page. This will bring up a blue box, confirming the report has been saved.

Click Run Report.

This will bring you to a new page with results from the report displayed.

Columns in the report results

Borrowernumber

The borrowernumber that appears in the results of this report will be the number on the patron who used the star ratings.

For more details about borrowernumbers, please check our Help Centre or contact Interleaf Technology directly.

Biblionumber

The biblionumber that appears in the results of this report will be the number of the record the rating has been applied to.

For more details about biblionumbers, please check our Help Centre or contact Interleaf Technology directly.

Rating_value

This is the average star rating the record has been given.

Timestamp

This is a record of the last time a rating was applied.

Version	Date	Detail	Author
1.0	26/05/20	Document created	Holly Cooper
2.0	26/05/20	Transferred to Zoho	Holly Cooper
2.1	21/01/21	Adding TOC	Holly Cooper
2.2	26/03/26	Updating for newer release of Koha	Holly Cooper

• Related Articles

• How to use a Star rating on the OPAC

  It is possible to allow patrons on the OPAC to rate items a certain number of stars. These ratings can then be viewed by other patrons on the OPAC and reported on by staff members on the staff side. For details of reporting on these ratings please ...

• Scooter - Start of Term Instructions

  Scooter 2 Start of Term Document This document is intended to be a set of guidelines for starting a new school year with Scooter. Included in it are answers to some commonly asked questions and links to resources to help you get started, or return to ...

• How to Find and Run a SQL Report

  What are reports for? Reports are used to find and present data about the information on the system in a structured manner. Reports use SQL to ask questions of the Koha database. How to find reports on your system Go to the Reports module on the Koha ...

• Overview of some SQL Report Functions

  Overview of SQL Report Functions This FAQ is an example of a simple report describing the “anatomy” of the SQL code used.  Details about the different functions are outlined in the table below the report.  Some functions are mandatory to use in order ...

• How to add an alias to a field in an SQL report

  This document will outline how to define a custom label for a field in an SQL report. Fields in SQL report results will default to the name of the field in the Koha database. However, it is possible to add a custom label that is of more use to the ...