Django query question

Question

I have a view & template which displays a list of types of items. This is ok, but instead of displaying all different the types of items for that client. What I want to do is display the list of types individually.

For example, if an Item has a type stored say "General". I want to display all items that has a type only called "General".

Views

   def client_summary(request, client_id):
        client = None
        items = None
    try:
        client = models.Client.objects.get(pk = client_id)
        items = client.storageitem_set.all()
        total_items = items.count()
        except:
            return HttpResponse(reverse(return_clients))
        return render_to_response('client_summary.html', {'items':items, 'total_items':total_items, 'client':client}, context_instance = RequestContext(request))

Template

Summary for {{client.name}}
Total Number of Items: {{total_items}}
{%for item in items}
        {{item.type}}
{%endfor%}

Ignacio Vazquez-Abrams · Accepted Answer · 2011-03-28 12:40:52Z

8

Sounds like you want to regroup on type.

answered Mar 28, 2011 at 12:40

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Dinu · Accepted Answer · 2011-03-28 12:39:38Z

1

You can try `client.storageitem_set.filter(type=YOUR_TYPE):

def client_summary(request, client_id):
    client = None
    items = None
    try:
        client = models.Client.objects.get(pk = client_id)
        items = client.storageitem_set.filter(type="General")
        total_items = items.count()
        except:
           return HttpResponse(reverse(return_clients))
        return render_to_response('client_summary.html', {'items':items, 'total_items':total_items, 'client':client}, context_instance = RequestContext(request))

docs: Following relationships backwards

answered Mar 28, 2011 at 12:39

Daniel Dinu

1,76612 silver badges16 bronze badges

3 Comments

Timmy O'Mahony Over a year ago

that will only allow for one type though? I think he wants to list all the types that may exist

Daniel Dinu Over a year ago

yes, but he can use an __in query, the idea is to read the docs :)

Shehzad009 Over a year ago

Actually this is what I want. This does work. The problem is that each type has a number. So it would complain that the value is not an interger.

Collectives™ on Stack Overflow

Django query question

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related