Login

Filtering foreignkey fields in django admin

Author:
forgems
Posted:
June 9, 2009
Language:
Python
Version:
1.0
Score:
3 (after 5 ratings)

Sometimes you need to filter foreignkey choices in admin interface, to objects created by user or meeting some other condition. In django 1.0 there is no formfield_for_foreignkey method in ModelAdmin class so we have to make a workaround. Here is the solution I have found to be the easiest for me.

1
2
3
4
5
6
7
8
class MyAdmin(admin.ModelAdmin):
    def get_form(self, request, obj=None, **kwargs):
        form = super(MyAdmin,self).get_form(self,request, obj,**kwargs)
        # form class is created per request by modelform_factory function
        # so it's safe to modify
        #we modify the the queryset
        form.base_fields['foreign_key_field].queryset = form.base_fields['foreign_key_field].queryset.filter(user=request.user)
        return form

More like this

  1. "Magic Link" Management Command by webology 3 months ago
  2. Closest ORM models to a latitude/longitude point by simonw 3 months ago
  3. Log the time taken to execute each DB query by kennyx46 3 months ago
  4. django database snippet by ItsRLuo 3 months, 1 week ago
  5. Serialize a model instance by chriswedgwood 4 months ago

Comments

dave.leblanc (on December 6, 2012):

Thanks for the snippet was exactly what I was looking for

I found a couple typos in implementing a revised example is below

class MyAdmin(admin.ModelAdmin):
    def get_form(self, request, obj=None, **kwargs):
        form = super(MyAdmin,self).get_form(request, obj,**kwargs)
        # form class is created per request by modelform_factory function
        # so it's safe to modify
        #we modify the the queryset
        form.base_fields['foreign_key_field'].queryset = form.base_fields['foreign_key_field'].queryset.filter(user=request.user)
        return form

#

Shafeenes (on January 16, 2020):

hello sir where should i paste this file in and what modification should i do my my files

#

Please login first before commenting.