On 2/6/07, Enrico <[EMAIL PROTECTED]> wrote: > > Hi Russel, > > I think that it doesn't solve the problem. > > I can use your solution to get my friends. But I need to include > people who added me in the same listing. > > To get a list of people who added me I can use: > people_who_added_me = > auth.models.User.objects.filter(profile__friends=my_id) > > My problem is to get my friends and people who added me in the same > listing. > To do this I should be able to somehow use the Q object to build an OR > lookup. > > As I said, the relationship isn't symmetrical, so I may not be present > in the friends list of someone in my own list.
You're on the right track - all you're missing is the reverse angle on the friends m2m field. You have defined a related_name of 'friends'; this means that there is a user.friends (the reverse direction), and a user.profile.friends (the forward direction). The following two queries should return different results: users = auth.models.User.filter(profile__friends=some_user_id) users = auth.models.User.filter(friends=some_user_id) The distinction might be a little easier to understand if you drop the related_name clause; if you remove that clause, there will be user.profile.friends, and user.friend_set. users = auth.models.User.filter(profile__friends=some_user_id) users = auth.models.User.filter(friend_set=some_user_id) Compose two individual Q objects (one traversing each direction), and use an OR in the filter clause over User.objects.filter(), and you're done. Yours, Russ Magee %-) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
