Django ModelForm instance with custom queryset for a specific field

Question

I have a model not unlike the following:

class Bike(models.Model):
    made_at = models.ForeignKey(Factory)
    added_on = models.DateField(auto_add_now=True)

All users may work at a number of factories and therefore their user profiles all have a ManyToManyField to Factory.

Now I want to construct a ModelForm for Bike but I want the made_at list to consist of only factories at which the current user works. The idea is that users should be able to add bikes that they've assembled and enter which of the factories the bike was made at.

How do I do that?

And, for what it is worth, your question is more readable and to the point than the one I have pointed as a dupe... — cethegeek, Nov 30 '09 at 18:52
Nah... I even deleted the comment where I said it was about to get deprecated. For some reason I had my mind that it was. I think I read a ticket about it... But the docs have it there, and there is no sign of deprecation in the source. Just ignore me. :-) And it is `auto_now_add` btw. — cethegeek, Nov 30 '09 at 18:56
Here is the ticket where I read `auto_now_add` was to be deprecated: http://code.djangoproject.com/ticket/6434. But ignore it because nothing in the code says it is... — cethegeek, Nov 30 '09 at 18:58
possible duplicate of [How do I filter ForeignKey choices in a Django ModelForm?](http://stackoverflow.com/questions/291945/how-do-i-filter-foreignkey-choices-in-a-django-modelform) — Azd325, Mar 19 '14 at 09:54

score 47 · Answer 1 · answered Nov 30 '09 at 18:42

47

try something like this in the view

form  = BikeForm()
form.fields["made_at"].queryset = Factory.objects.filter(user__factory)

modify the Factory queryset so that it identifies the factory which the user works at.

answered Nov 30 '09 at 18:42

Dave

2,849
4
28
20

score 14 · Accepted Answer · edited May 23 '17 at 11:33

You question might be a dupe of this.

S. Lott's answer there is the ticket to solve your problem. He answered:

ForeignKey is represented by django.forms.ModelChoiceField, which is a ChoiceField whose choices are a model QuerySet. See the reference for ModelChoiceField.

So, provide a QuerySet to the field's queryset attribute. Depends on how your form is built. If you build an explicit form, you'll have fields named directly.

form.rate.queryset = Rate.objects.filter(company_id=the_company.id) If you take the default ModelForm object, form.fields["rate"].queryset = ...

This is done explicitly in the view. No hacking around.

score 0 · Answer 3 · answered Jul 13 '18 at 19:47

0

Nowaday, you should use:

    form.base_fields['alumno_item'].queryset = AlumnoItem.objects.prefetch_related(
        'alumno',
        'alumno__estudiante',
        'alumno__estudiante__profile',
        'item'
    )

answered Jul 13 '18 at 19:47

helpse

1,518
1
18
29

I don't think that is correct. It means you are modifying the form at the wrong time (not from the view). – Apollo Data Jul 26 '20 at 03:57

Django ModelForm instance with custom queryset for a specific field

3 Answers3

Linked