Exclude one Field value in Foreign Key dropdown list in Model Form

Question

I have a model like this:

class Package(models.Model):
    package_name = models.CharField(max_length=200)
    package_price = models.IntegerField()

class UserPackage(models.Model):
    user = models.ForeignKey(User)
    package = models.ForeignKey(Package)

ModelForm like this:

class UserPackageForm(ModelForm):
    class Meta:
        model = UserPackage
        exclude = ['user']

I want to list the packages excluding Free that's why I am doing like this:

def __init__(self, *args, **kwargs):
            super(UserPackageForm, self).__init__(*args, **kwargs)
            self.fields['package'].queryset = Package.objects.exclude(package="Free")

It is showing Free package too. What's wrong?

Possible duplicate of [filtering dropdown values in django admin](https://stackoverflow.com/questions/6581520/filtering-dropdown-values-in-django-admin) — P. de Boer, Aug 07 '18 at 09:14

Bradia · Answer 1 · 2013-11-29T05:33:59.420

3

exclude argument is wrong, try package_name instead of package.

from django.forms.models import BaseModelFormSet

class UserPackageForm(ModelForm):
     def __init__(self, *args, **kwargs):
            super(UserPackageForm, self).__init__(*args, **kwargs)
            self.fields['package_name'].queryset = self.fields['package_name '].queryset.exclude(package_name="Free")

edited Nov 29 '13 at 05:33

answered Nov 29 '13 at 04:53

Bradia

827
5
8

also make a change to __init__ function. use self.queryset – Bradia Nov 29 '13 at 05:05
hopfully the last change I made will do the trick.self.fields['package_name'].queryset = self.fields['package_name '].queryset.exclude(package_name="Free") – Bradia Nov 29 '13 at 05:35

score 1 · Answer 2 · answered Nov 29 '13 at 19:59

1

Try this
self.fields['package'].queryset = Package.objects.exclude(package__name="Free")

answered Nov 29 '13 at 19:59

Arpit

953
7
11

Exclude one Field value in Foreign Key dropdown list in Model Form

2 Answers2