id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
31401	Exclude on M2M with F-function not working	Ronny Vedrilla	nobody	"I have the following models:

    class Activity(models.Model):
       user = models.ForeignKey(User, related_name='activities')
       project = models.ForeignKey(Project, related_name='activities')
    

    class Project(models.Model):
       assignees = models.ManyToManyField(User, related_name='projects')

Now I want to query for all the activities which belog to a user which is NOT in the projects assignees.

My query:

    Activity.objects.exclude(project__assignees=F('user'))

Problem is, I always get this error:

> django.db.utils.OperationalError: (1054, ""Unknown column 'U2.id' in 'on clause'"")

Im working on django 2.2.11 and MySQL.

I found a couple of [old django bugs][1] but they are supposed to be fixed since ages.

Any ideas how I can solve my problem? My activity table is huge and I need an efficient way. And I'd be happy to not use raw queries.

Thanks!


  [1]: https://code.djangoproject.com/ticket/28551"	Bug	new	Database layer (models, ORM)	2.2	Normal				Unreviewed	0	0	0	0	0	0