Hi Michael Thanks for the response
I don't think select_related works backwards on relations, so I wouldn't be able to use it for the rating_set part I think I've possibly come across a nice solution, by generating Left Join Queries through django's own sql query mechanism http://groups.google.com/group/django-users/browse_thread/thread/94e0c5c5c6b29df7/703b3faccce6e803 This post suggests you can Extend the Q object with your own that adds a left join code chunk not tested it out yet, but it looks good On 4/15/07, Michael Trier <[EMAIL PROTECTED]> wrote: > > > Tejas, > > Can you not use the select_related on the queryset to eager load the > relationships? > > Michael > > On 4/15/07, Michael Trier <[EMAIL PROTECTED]> wrote: > > On 4/15/07, Tejas Shah <[EMAIL PROTECTED]> wrote: > > > Thanks guys > > > > > > The problem in this case with querying against ItemRatingsByGroup is > that > > > not all Items are in there. > > > > > > Only the items that have been rated are in items rated by group > > > > > > I'm looking to display as following: > > > > > > The Group > > > All the items in the group > > > A rating for each item - if a rating exists > > > > > > So I need to go about it by getting all the items for the group at > some > > > point > > > > > > > > > > > > > Ah, I missed that piece of the puzzle. Sorry. I see what you're > saying. > > > > Michael > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
