Hi, Here's the SQL code:
SELECT `projects_project`.`id`,`projects_project`.`name`,`projects_project`.`created_by_id`, FROM `projects_project` INNER JOIN `projects_participant` AS `projects_project__participants` ON `projects_project`.`id` = `projects_project__participants`.`project_id` WHERE ((`projects_project`.`created_by_id` = 1 OR `projects_project__participants`.`user_id` = 1)) Any idea? Thanks, Julien On Feb 11, 6:45 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Sun, 2008-02-10 at 23:14 -0800, Julien wrote: > > Hi there, > > > I'd like to pull out all the projects that a given user is involved > > in, either as a creator or as a participant of the projects: > > > class Project(models.Model): > > name = models.CharField(max_length=200) > > created_by = models.ForeignKey(User) > > > class Participant(models.Model): > > project = models.ForeignKey(Project) > > user = models.ForeignKey(User) > > > I'm running the following code: > > > q1 = Project.objects.filter(created_by=user) > > q2 = Project.objects.filter(participants__user=user) > > projects = q1 | q2 > > > Unfortunately it doesn't return what I'd expect. > > q1 and q2 work individually, but q1 | q2 returns a strange list of > > projects. By "strange" I mean that I can't figure out what reasoning > > is going on to provide that result. > > What is the SQL statement being executed (have a look in the FAQ if you > don't know how to view the SQL statement). > > There are some bugs in 'or' combinations. I don't know if you're hitting > one of those or not. > > Regards, > Malcolm > > -- > Tolkien is hobbit-forming.http://www.pointy-stick.com/blog/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
