Ratings sort is confusing

[thereido]

When sorting by date, the sorting for items with the same rating day, if seems random. Ideally the sorting would be showing the items rated last if the sort is descending, which is the default. Ascending sort would show items rated first.

Example:

• Item 1 was rated yesterday morning
• Item 2 was rated yesterday evening
• Item 3 was rated today

Shown current with default sort:

• [Item 1 or Item 2], not sure
• The other of items 1 or 2
• Item 3

Suggestion for default sort:

• Item 1
• Item 2
• Item 3

[thereido]

Current ratings' date is only specific to the day, not the time.

• Option 1) Store rating day include the time in the DB schema
• Option 2) Store rating time on a new column in the DB schema
• Option 3) Sort by rating day and timestamp

Option 3 affects the least code. I would mostly do what you want.

ORDER BY rating.yourRatingDate desc, rating.ts desc

In the example in the issue description (Item 1, Item 2, Item3)... If Item 1 was modified yesterday after Item 2 was created the sort would be wrong.

[thereido]

I am doing option 3 because it is the option with the least code to be affected.