How to Report on Star Ratings
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.
Step 1 - Navigate to the report creation area
Go to Reports > Guided Reports > + Create from SQL.
Step 2 - 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 Update SQL. 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
This is the internal number that is created and applied to all patron accounts. The borrowernumber that appears in the results of this report will be the number on the patron who used the star ratings.
Biblionumber
This is the internal number that is created for the overall bibliographic record. The biblionumber that appears in the results of this report will be the number of the record the rating has been applied to.
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.
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 ...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 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. This information is drawn from tables storing all information about the system which can be found here: ...Options for the OPAC
Options for the OPAC - Non- JCSP This table of information is intended to outline the various options non-JCSP sites have for manipulating the site to improve student experiences. - Easy and usable search facility that generates returns to students ...How to Find and Run an SQL Report
What are reports for? Reports are used to find and present data about the information on the system in a structured manner. This information is drawn from tables storing all information about the system which can be found here: ...