create ManyToManyField using field in through table as condition

Asked Oct 07 '19 at 19:14

Active Oct 07 '19 at 19:14

Viewed 31 times

This is what I want to achieve:

class Event(Model):
    attendees = ManyToManyField(User, through='Involvement', related_name='attended_events')
    interested_users = ManyToManyField(User, through='Involvement', related_name='interested_in_events')
    organizers = ManyToManyField(User, through='Involvement', related_name='organized_events')

class Involvement(Model):
    event = ForeignKey(Event, CASCADE)
    user = ForeignKey(User, CASCADE)
    involvement = CharField(choices=(('INTERESTED', 'Interested'), ('ATTENDED', 'Attended'), ('ORGANIZED', 'Organized')))

The error I'm receiving:

 The model has three identical many-to-many relations through the intermediate model 'app.ActivityInvolvement'.

I know limit_choices_to doesn't work on ManyToManyField, how would I go about making this happen, without creating 3 through tables with the same structure?

asked Oct 07 '19 at 19:14

jc127

Why do you need through tables at all? Why not have three completely separate m2m fields? – Daniel Roseman Oct 07 '19 at 19:20
[this](https://stackoverflow.com/a/26436863/1339013) may help. – Shakil Oct 07 '19 at 19:22

create ManyToManyField using field in through table as condition

0 Answers0