KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm looking to narrow a query set for a form field that has a foreignkey to the User's table down to the group that a user belongs to. The groups have been previously associated by me. The model might have something like the following: myuser = models.ForeignKey(User) And my ModelForm is very bare bones: class MyForm(ModelForm): class Meta: model = MyModel So when I instantiate the form I do something like this in my views.py: form = MyForm() Now my question is, how can I take the myuser field, and filter it so only users of group 'foo' show up.. something like: form.fields["myuser"].queryset = ??? The query in SQL looks like this: mysql> SELECT * from auth_user INNER JOIN auth_user_groups ON auth_user.id = auth_user_groups.user_id INNER JOIN auth_group ON auth_group.id = auth_user_groups.group_id WHERE auth_group.name = 'client'; I'd like to avoid using raw SQL though. Is it possible to do so?
Tags (comma-separated)
Save Edits
Cancel