Login

Filtering foreignkey fields in django admin

Author:
forgems
Posted:
June 9, 2009
Language:
Python
Version:
1.0
Tags:
filter admin foreignkey
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. Automatically setup raw_id_fields ForeignKey & OneToOneField by agusmakmun 8 months ago
  2. Crispy Form by sourabhsinha396 8 months, 3 weeks ago
  3. ReadOnlySelect by mkoistinen 9 months, 1 week ago
  4. Verify events sent to your webhook endpoints by santos22 10 months ago
  5. Django Language Middleware by agusmakmun 10 months, 2 weeks 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.