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
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 |