Thank you very much. This worked perfectly. Consequently it also fixed my
issue of those select boxes not reflecting changes in the list until the
web server was restarted since the data is now being pulled at
instantiation instead of in the class definition.
j
On Thursday, February 15, 2018 at 9:54:24 AM UTC-6, C. Kirby wrote:
>
> You can set the choices in the form __init__ to handle the issue:
>
> class FooJBossForm(Form):
> biz_service = MultipleChoiceField(
> choices=[],
> required=False,
> label='Business Service',
> widget=SelectMultiple(attrs={'class': 'form-control'}),
> )
>
> def __init__(self, *args, **kwargs):
> super(FooJBossForm, self).__init__(*args, **kwargs)
> try:
> self.fields['biz_service'].choices = BizService.objects.filter(
> biz_unit__bu_name='Foo',
> ).order_by('bs_name')\
> .values_list('bs_name',
> 'bs_name')\
> .distinct()
> except ProgrammingError:
> pass #OR Some placeholder choices
>
> Kirby
>
>
>
> On Thursday, February 15, 2018 at 9:56:56 AM UTC-5, jason...@gmail.com
> wrote:
>>
>> Hello everyone,
>>
>> I have a form field that is pulling choices from the database:
>>
>> class FooJBossForm(Form):
>> biz_service = MultipleChoiceField(
>> choices=BizService.objects.filter(
>> biz_unit__bu_name='Foo',
>> ).order_by('bs_name').values_list('bs_name', 'bs_name').distinct
>> (),
>> required=False,
>> label='Business Service',
>> widget=SelectMultiple(attrs={'class': 'form-control'}),
>> )
>>
>> ...
>>
>> This worked great until someone else on my team attempted to start with a
>> fresh DB and was getting "relation does not exist" errors trying to do the
>> initial import.
>>
>> Commenting out these "choices=" parameters in `forms.py` fixes the
>> issue. What's the right way to go about populating form field choices from
>> the DB at access time?
>>
>> Thanks,
>>
>> j
>>
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/ff2289b7-630b-4132-8d48-0ffc98715cdc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
