Jump to content

Include review date support in rating queries


AdinaG

Recommended Posts

The aggregated ratings table currently doesn't expose any date information, making it impossible to create time-based Custom Where queries for things like awards or annual recognition based on reviews.

It would be helpful if rating queries could optionally be filtered by a review received date or something (or if the aggregate table stored the last review date or supported date-range aggregation), allowing us to create Custom Lists such as:

Best Dance Floors of 2026

Best Restaurants This Year

Best Studios This Quarter

Similar to sites like https://tampabaybestofthebest.com/ that give out awards but theirs is based on votes, where JReviews would just be based on the average of the reviews received in a time frame.

This would enable annual and seasonal recognition pages driven entirely by community reviews without requiring a separate voting system.

Link to comment
×
×
  • Create New...