Jump to content

Recommended Posts

Posted (edited)

I have a Pages database. It uses star rating (not reviews!). I have set sorting by rating in descending order:

Could contain: Page, Text

The sorting is weird, though:

  1. Item with 15x5 stars and 1x1 star.
  2. Item with 17x5 stars only.
  3. Item with 25x5 stars and 3x1 star.
  4. Item with 23x5 stars only.
  5. Item with 6x5 stars and 1x1 star.
  6. Item with 16x5 stars and 1x6 stars.
  7. Item with 7x7 stars and 7x7 stars.

Does it make sense? Obviously, the item #4 should be placed at the very top, following by item #2.

Should it not be sorted by average as total rating divided by number of votes? Or what is meant with Sort by Rating?

 

Edited by Sonya*
  • Sonya* changed the title to Pages: Sort by Rating (Bug)
Posted

Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.

 

Posted (edited)

I can see the issue. Your code rounds the average rating to an integer. That's why there is no difference for the first 4 items and then the next two. You can see they have the same record_rating in the database. This is how you save it.

The rating_average (rating_value/rating_hits) with decimal would make a difference.

Could contain: Page, Text, File

 

Edited by Sonya*
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...