#31401: Exclude on M2M with F-function not working
-------------------------------------+-------------------------------------
Reporter: Ron | Owner: nobody
Type: Bug | Status: new
Component: Database | Version: 2.2
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
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
--
Ticket URL: <https://code.djangoproject.com/ticket/31401>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/049.5ff40318ad1c68f807af7118a7c01944%40djangoproject.com.
