Limit foreign key choices in select in an inline form in admin

by

Used request instance as temporary container for obj.
Overrided Inline method formfield_for_foreignkey to modify queryset.
This works at least on django 1.2.3.

class RoomInline(admin.TabularInline):

    model = Room

    def formfield_for_foreignkey(self, db_field, request=None, **kwargs):

        field = super(RoomInline, self).formfield_for_foreignkey(db_field, request, **kwargs)

        if db_field.name == 'inside_room':
            if request._obj_ is not None:
                field.queryset = field.queryset.filter(building__exact = request._obj_)  
            else:
                field.queryset = field.queryset.none()

        return field



class BuildingAdmin(admin.ModelAdmin):

    inlines = (RoomInline,)

    def get_form(self, request, obj=None, **kwargs):
        # just save obj reference for future processing in Inline
        request._obj_ = obj
        return super(BuildingAdmin, self).get_form(request, obj, **kwargs)

More Related Contents:

  1. Django: Set foreign key using integer?
  2. How do I add a Foreign Key Field to a ModelForm in Django?
  3. Django migration error :you cannot alter to or from M2M fields, or add or remove through= on M2M fields
  4. Django how to pass custom variables to context to use in custom admin template?
  5. Setting default value for Foreign Key attribute
  6. Django model with 2 foreign keys from the same table
  7. Dynamic fields in Django Admin
  8. (13: Permission denied) while connecting to upstream:[nginx]
  9. Issue with ManyToMany Relationships not updating immediately after save
  10. Django: Populate user ID when saving a model
  11. How to revert the last migration?
  12. How do you serialize a model instance in Django?
  13. Create Custom Error Messages with Model Forms
  14. Django delete FileField
  15. SocketException: OS Error: Connection refused, errno = 111 in flutter using django backend
  16. Why does django’s prefetch_related() only work with all() and not filter()?
  17. How to paginate Django with other get variables?
  18. Getting ‘DatabaseOperations’ object has no attribute ‘geo_db_type’ error when doing a syncdb
  19. ImportError: Couldn’t import Django
  20. Access kwargs from a URL in a Django template
  21. How to register users in Django REST framework?
  22. Get err_connection_refused accessing django running on wsl2 from Windows but can curl from Windows terminal
  23. Django admin DoesNotExist at /admin/
  24. Pass request context to serializer from Viewset in Django Rest Framework
  25. UnicodeEncodeError: ‘ascii’ codec can’t encode character
  26. How can I upload and download files with graphene-django?
  27. Django give Error 500 for all static files like CSS and Images, when DEBUG is False
  28. Django, query filtering from model method
  29. Parsing a Datetime String into a Django DateTimeField
  30. How can I test binary file uploading with django-rest-framework’s test client?

Leave a Comment