Returning unique values from a foreign key in a ListView

Hi everyone,

Goal

- I have a ListView built around ModelA. 

- ModelA has a foreign key to ModelB. 

- I want to return a list with all unique entries of a required field (i.e. 'foo') from ModelB.

Context

I have a table of clients (ModelA) and a table of jobs I do (ModelB), connected via foreign key - I want to retrieve a distinct list of all the jobs I do for the clients so I can render that into the template and make a user-facing filter.

Problem 1

Can't access values in ModelB using get_queryset()  as using this for ModelA and I don't know how to query multiple tables in such a statement:

views.py


from .models import ModelA
from django.views.generic import ListView, DetailView


# Create your views here.
class IndexView(ListView):
    context_object_name = 'modela_list'
    template_name = 'modela/index.html'


    def get_queryset(self):
        return ModelA.objects.order_by('title')

Outcome 1

Couldn't work out how to return the data from ModelA *AND* a unique list of 'foo' values. Can return ALL values of 'foo' including duplicates (i.e. 'Hello', 'Hello', 'World', 'World', 'Hello', rather than the desired 'Hello', 'World')

Problem 2

Tried to do get_context_data though my understanding of this is very weak:

views.py



[code from Problem 1]
    [...]
    def get_context_data(self, **kwargs):
        context = super(IndexView, self).get_context_data(**kwargs)
        qs = context['modela_list']
        list_of_values = qs.order_by().values('foo').distinct()
        context.update(
            {
                'list_of_values': list_of_values,
            }
        )
        return context

Outcome 2

Could return the unique values for the FOREIGN KEY values as they are in ModelA, could not return the assigned values from ModelB (i.e. '1', '2' returned, instead of 'Hello', 'World')

Overall Outcome

So I've managed to either get ALL the values of the required field from ModelB OR I can get the distinct values of the foreign key field from ModelA - but not the distinct values of the required field from ModelB!

Any help would be greatly appreciated!

Rich

--
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+unsubscribe@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/10f50536-b5cc-4e30-8d28-a8ca1e0dce29%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.