London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
AI OnAI Off
Query for entity with highest rating within a specific category?
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.
I want to create a list of the highest ranked Clubs (or any other entity for that matter) within a single Category, which is the best way of achieving that?
Since I cannot sort a query based on AvgRating (see this thread), I´m stuck getting all entities for a Category and then sorting on AvgRating to get what I want. Seems like a lot of overhead to get hundreds/thousands of items and then sorting them to get the two items with the highest rating.
Any ideas?