如何在Django后台根据已选字段限制外键表单选项？

我了解此前已有相关讨论，但答案多提及使用第三方包，想知道是否存在基于原生Django的解决方案（相关帖子距今已有数年）。

我正在开发一款音乐类APP，包含Artist、Album、Track模型。希望在后台管理面板添加新Track时，当选择某个Artist后，Album的可选范围被限制为该Artist的专辑，但始终无法实现。起初我尝试像模型Admin的list_filter那样使用双下划线来关联关系，但并未生效。

为解决该问题，我给Track模型添加了artist字段，但不确定是否有此必要。目前我尚未开发该APP的大部分视图，仅需实现后台管理面板添加新Track的功能。

模型代码 #

class Artist(models.Model):
    name = models.CharField(max_length=100, verbose_name="Artist")
    genre = models.CharField(max_length=100)
    country = CountryField(blank_label="(select country)")
    is_approved = models.BooleanField(default=False)

    def __str__(self):
        return self.name


class Album(models.Model):
    artist = models.ForeignKey(Artist, on_delete=models.CASCADE)
    name = models.CharField(max_length=100, verbose_name="Album")
    release_date = models.DateField()
    is_approved = models.BooleanField(default=False)

    def __str__(self):
        return self.name


class Track(models.Model):
    artist = models.ForeignKey(Artist, on_delete=models.CASCADE, verbose_name="Artist")
    album = models.ForeignKey(Album, on_delete=models.CASCADE, verbose_name="Album")
    listing_num = models.IntegerField(default=0)
    title = models.CharField(max_length=100)
    duration = models.CharField(max_length=10)
    spotify_link = models.CharField(max_length=256)
    apple_music_link = models.CharField(max_length=256)
    is_approved = models.BooleanField(default=False)

    def __str__(self):
        return self.title

表单代码 #

class TrackForm(ModelForm):
    class Meta:
        model = Track
        fields = [
            "artist",
            "album",
            "listing_num",
            "title",
            "duration",
            "spotify_link",
            "apple_music_link",
        ]

Admin代码 #

class TrackAdmin(admin.ModelAdmin):
    model = Track
    list_display = [
        "artist",
        "album",
        "listing_num",
        "title",
        "duration",
        "is_approved",
    ]
    list_filter = ["album__name", "artist__name", "is_approved"]

第一步：优化模型（可选，避免数据冗余） #

Track模型中的artist字段可以去掉，因为通过album.artist就能关联到对应的艺术家，无需重复存储。修改后的Track模型如下：

class Track(models.Model):
    album = models.ForeignKey(Album, on_delete=models.CASCADE, verbose_name="Album")
    listing_num = models.IntegerField(default=0)
    title = models.CharField(max_length=100)
    duration = models.CharField(max_length=10)
    spotify_link = models.CharField(max_length=256)
    apple_music_link = models.CharField(max_length=256)
    is_approved = models.BooleanField(default=False)

    def __str__(self):
        return self.title

    # 新增属性，用于Admin列表显示艺术家
    @property
    def artist(self):
        return self.album.artist

第二步：修改Track表单 #

如果去掉了Track的artist模型字段，需要在表单中添加一个临时的artist选择字段，用于后台选择并过滤专辑，同时验证专辑与艺术家的关联：

from django import forms
from .models import Track, Artist, Album

class TrackForm(forms.ModelForm):
    # 添加临时的艺术家选择字段
    artist = forms.ModelChoiceField(queryset=Artist.objects.all(), required=True, verbose_name="Artist")

    class Meta:
        model = Track
        fields = [
            "album",
            "listing_num",
            "title",
            "duration",
            "spotify_link",
            "apple_music_link",
        ]

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        # 编辑已有Track时，默认选中对应艺术家并过滤专辑
        if self.instance.pk:
            selected_artist = self.instance.album.artist
            self.fields['artist'].initial = selected_artist
            self.fields['album'].queryset = Album.objects.filter(artist=selected_artist)
        else:
            # 新增时默认显示所有专辑，后续通过JS动态过滤
            self.fields['album'].queryset = Album.objects.all()

    def clean(self):
        cleaned_data = super().clean()
        selected_artist = cleaned_data.get('artist')
        selected_album = cleaned_data.get('album')
        # 验证专辑是否属于选中的艺术家
        if selected_artist and selected_album and selected_album.artist != selected_artist:
            raise forms.ValidationError("所选专辑不属于该艺术家")
        return cleaned_data

    def save(self, commit=True):
        instance = super().save(commit=False)
        # 无需手动设置artist，通过album关联即可
        if commit:
            instance.save()
        return instance

如果保留Track模型中的artist字段，只需修改表单的__init__方法来过滤专辑：

class TrackForm(forms.ModelForm):
    class Meta:
        model = Track
        fields = [
            "artist",
            "album",
            "listing_num",
            "title",
            "duration",
            "spotify_link",
            "apple_music_link",
        ]

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        if self.instance.pk:
            self.fields['album'].queryset = Album.objects.filter(artist=self.instance.artist)

第三步：修改TrackAdmin #

重写formfield_for_foreignkey方法处理编辑时的专辑过滤，并添加JS实现动态交互：

from django.contrib import admin
from .models import Track
from .forms import TrackForm

class TrackAdmin(admin.ModelAdmin):
    model = Track
    form = TrackForm
    list_display = [
        "artist",
        "album",
        "listing_num",
        "title",
        "duration",
        "is_approved",
    ]
    # 如果优化了模型，这里的过滤条件要调整
    list_filter = ["album__artist__name", "album__name", "is_approved"]

    def formfield_for_foreignkey(self, db_field, request, **kwargs):
        if db_field.name == "album" and request.resolver_match.kwargs.get('object_id'):
            # 编辑已有Track时，过滤专辑为当前艺术家的作品
            track = Track.objects.get(pk=request.resolver_match.kwargs['object_id'])
            artist = track.artist if hasattr(track, 'artist') else track.album.artist
            kwargs["queryset"] = Album.objects.filter(artist=artist)
        return super().formfield_for_foreignkey(db_field, request, **kwargs)

    # 引入自定义JS文件
    class Media:
        # 替换成你的APP名称，比如"music/admin/js/track_album_filter.js"
        js = ('your_app_name/admin/js/track_album_filter.js',)

第四步：添加动态过滤的JS文件 #

在你的APP的static/admin/js/目录下创建track_album_filter.js文件，内容如下：

document.addEventListener('DOMContentLoaded', function() {
    const artistSelect = document.getElementById('id_artist');
    const albumSelect = document.getElementById('id_album');
    // 保存初始的专辑选项，用于重置
    const initialAlbumOptions = Array.from(albumSelect.options).map(opt => ({value: opt.value, text: opt.text}));

    artistSelect.addEventListener('change', function() {
        const artistId = this.value;
        if (!artistId) {
            // 未选择艺术家时恢复所有专辑选项
            albumSelect.innerHTML = '';
            initialAlbumOptions.forEach(opt => {
                const option = document.createElement('option');
                option.value = opt.value;
                option.textContent = opt.text;
                albumSelect.appendChild(option);
            });
            return;
        }

        // 发送请求获取该艺术家的专辑列表
        // 替换成你的APP名称，比如"/admin/music/album/"
        fetch(`/admin/your_app_name/album/?artist__id=${artistId}`)
            .then(response => response.text())
            .then(html => {
                const parser = new DOMParser();
                const doc = parser.parseFromString(html, 'text/html');
                const albumRows = doc.querySelectorAll('#changelist-form tbody tr');
                
                albumSelect.innerHTML = '';
                // 添加空选项
                const emptyOption = document.createElement('option');
                emptyOption.value = '';
                emptyOption.textContent = '---------';
                albumSelect.appendChild(emptyOption);
                
                // 填充过滤后的专辑选项
                albumRows.forEach(row => {
                    const albumId = row.querySelector('input[type="checkbox"]').value;
                    const albumName = row.querySelector('td:first-child').textContent.trim();
                    const option = document.createElement('option');
                    option.value = albumId;
                    option.textContent = albumName;
                    albumSelect.appendChild(option);
                });
            });
    });
});

注意事项 #

1. 替换代码中的your_app_name为你实际的Django应用名称。
2. 确保已启用Django的静态文件服务，开发环境中可通过python manage.py collectstatic收集静态文件（生产环境需配置静态文件存储）。

内容的提问来源于stack exchange，提问作者Caelan Quigley