tags:

views:

56

answers:

3
+1  Q: 

how to limit the foreignkey dropdown with constraints?

Hi all,

I have a database which keeps track of interaction between two different teams (represented in the admin interface by two different groups). For some fields, i have a foreignkey to Users database, and i would like to limit the dropdown people to only the specific groups.

If anyone have any suggestions, it would be much appreciated!

Jason

+2  A: 

You can change the underlaying queryset for the form field: http://stackoverflow.com/questions/291945/how-do-i-filter-foreignkey-choices-in-a-django-modelform

lazerscience  2010-06-17 18:18:23
It seems to say that it should be done in the view, but i'm not sure how to access the view, the only thing i have access to is the model class and the modeladmin class. Any particular directional suggestions would be greatly appreciated!
FurtiveFelon  2010-06-17 18:55:10
You should use a custom form and do it in the form's `__init__`! def __init__(self, *args, **kwargs): super(MyForm, self).__init__(*args, **kwargs) self.fields["user"].queryset = User.objects.filter(...)
lazerscience  2010-06-17 19:50:35
+1  A: 

To override the choices for a foreign key field in Django admin app, write a formfield_for_foreignkey method.

Alasdair  2010-06-17 19:24:13
+1  A: 

You're looking for limit_choices_to.

Ignacio Vazquez-Abrams  2010-06-17 19:29:15
Hey thanks for your answer! However, i think the user-groups relationship resides on different tables in django admin, how would i filter in that case?
FurtiveFelon  2010-06-18 19:43:28
With `Q` objects. `Q(group__icontains=u'user')`
Ignacio Vazquez-Abrams  2010-06-18 19:46:52
Hey Ignacio, I'm still kinda confused on how to do this. After digging through the code for auth module further, i have found that groups is defined in User class as follows: groups = models.ManyToManyField(Group, verbose_name=_('groups'), blank=True,). The query is based on Users, so i would like to check whether the current User in question is in group "Legal". Note that the Group model have a ID, so the name is not stored in User directly. Thank you very much for all your help!
FurtiveFelon  2010-06-18 20:33:22
`ForeignKey(User, limit_choices_to={'groups__name': u'Legal'}, ...)`
Ignacio Vazquez-Abrams  2010-06-18 20:43:57
thanks a lot for all your help!
FurtiveFelon  2010-06-21 12:45:47

related questions

Django: Print url of view without hardcoding the url
Django Calendar Widget?
Can the HTTP version or headers affect the visual appearance of a web page?
Project design / FS layout for large django projects
Extending the User model with custom fields in Django
How to generate urls in django
Always including the user in the django template context
Screencasts for Django/Python?
Using Django time/date widgets in custom form
How do I add data to an existing model in Django?
Setup django with WSGI and apache
Altering database tables in Django
Django Templates and variable attributes.
Django ImageField core=False in newforms admin
How can I render a tree structure (recursive) using a django template?
Cleanest & Fastest server setup for Django
Unicode vs UTF-8 confusion in Python / Django?
Does Hostmonster support Django
Specifying a mySQL ENUM in a Django model
Represent Ordering in a Relational Database
updating an auto_now DateTimeField in a parent model w/ Django
Version track, automate DB schema changes with django
Learning Ruby on Rails any good for Grails?
What Hosting Service is best for Django applications?
Class views in Django