Honza Král wrote:
> it occured before on the mailing list...
>
> if you add select_related(), it will work...
>
> the problem is that specifying ordering like this doesn't force the
> join in the query so you might end up with a query that sorts on
> something that just isn't there...
That didn't work either:
Book.objects.all().select_related()
.order_by('-bookshop_bookstat.avg_rating')[0:10]
still gives me:
ERROR: missing FROM-clause entry for table "bookshop_bookstat"
Perhaps I'm doing something else wrong. These are my models:
-----------------------------------------------------------------
class Book(models.Model):
....
class BookStat(models.Model):
book = models.OneToOneField(Song, related_name='stats')
avg_rating = models.FloatField(max_digits=2, decimal_places=1)
...
-----------------------------------------------------------------
We're doing this because the statistics are calculated in cron jobs.
Btw, what if a certain book doesn't have statistics (yet)? Should I be
dropping back into SQL? :-)
- bram
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
