Django snippets: filtered ModelChoiceField queries

class MyModelForm(forms.ModelForm):
    def __init__(self, *args, **kwargs):
        super(MyModelForm, self).__init__(*args, **kwargs)
        if self.instance:
            self.fields['myfield'].queryset = \
                MyOtherModel.objects.filter(
                    Q(active=True)|Q(pk=self.instance.myfield_id))

    class Meta:
        model = MyModel

ModelChoiceField allows you to use filtered queries to simplify your forms. This is great for adding objects but can fall down when you edit an existing object and the original query no longer contains the referenced field (e.g. I like to use an "active" field in several objects).

The fix is simply to include an extra param: Q(pk=object_id). You have to do this in the init method to get the object_id.

A nice thing about this is that it works for ModelForms as well as custom Forms.

Author:: robharvey
Posted:: March 2, 2008
Language:: Python
Tags:: modelchoicefield modelform newforms
Score:: 3 (after 3 ratings)

Django snippets

filtered ModelChoiceField queries

Tools

Comments

Snippets

About