I can access my database with django and query it with objects.get() but objects.filter() will not work

Question

I am just making a simple website as I am learning django.

I have a view function that looks like this:

  def vieworkout(request):
        date= datetime.today()
        obj = userworkouts.objects.filter(userid=52)
        date = request.POST['date']
        
        
        
        
        context = {
            'exercise': obj.exercise
        }
    
        return render(request, 'clientIndex.html', context)

when I use userworkouts.object.get() I can pass the exercise object no problem. When I change it to filter I get an error, "'QuerySet' object has no attribute 'exercise'". Does anyone know why this is happening?

Robert Moskal · Answer 1 · 2020-10-31T03:34:38.133

1

Because the .get returns a single object and the .filter returns a list like object. You have to grab the first result.

Try this:

obj = userworkouts.objects.filter(userid=52).first()

If you want to render the entire collection, don't use first and pass the entire list into your template:

def vieworkout(request): 
    workouts=userworkouts.objects.filter(userid=52)
    return render(request, 'clientIndex.html', { 'workouts': workouts })

In your template you can iterate through the workouts and dot into each object's properties.

edited Oct 31 '20 at 03:34

answered Oct 31 '20 at 00:57

Robert Moskal

21,737
8
62
86

I see, I want to pass all the object that match 52 to my html page. How do I change the context to include multiple objects? – Jim Czerniak Oct 31 '20 at 01:04
Just pass in obj and iterate over the collection in your template. – Robert Moskal Oct 31 '20 at 01:10
But if I use first() I'm only getting one object. Sorry I am new at this – Jim Czerniak Oct 31 '20 at 01:14
Don't use first. Pass in the whole queryset. – Robert Moskal Oct 31 '20 at 02:27

I can access my database with django and query it with objects.get() but objects.filter() will not work

1 Answers1