Displaying the Average Rating

The average rating that is displayed on the Search Details and Search Results Web pages is the value of the avg_rating column of the title table, stored in the FmLib SQL Server™ database. Modifying the Title Table tells you how the title table used by the Corporate Media Library application in Scenario 1 has changed to support critique functionality. The average rating is not used by the Outlook piece of the CML/LitCrit application.

The Search Results Web page now displays the average rating for each title the page lists. Avg. Critique Rating on the Search Results Page describes the additional script that implements the display of the rating.

The Search Details Web page also displays the average rating for one title, and Avg. Critique Rating on the Search Details Page describes the additional script that implements the display of the rating.