how to get nested objects in django

Question

models.py

class BuyNotes(models.Model):
    student = models.ForeignKey(to=Student, on_delete=models.SET_NULL, null=True)
    note = models.ForeignKey(to=Notes, on_delete=models.SET_NULL, null=True)
    buy_at = models.DateField(auto_now_add=True)
    amount = models.IntegerField(default=0, null=True)

    class Meta:
        unique_together = [['note', 'student']]

views.py

def allNotesStudent(request):
    user = User.objects.get(username=request.session['user'])
    student = Student.objects.get(user=user)
    buy_notes = BuyNotes.objects.filter(student=student).get(note)

I know last line is wrong. how to get all objects of note that a student bought

user = request.user would do for getting current user

SANGEETH SUBRAMONIAM
– SANGEETH SUBRAMONIAM

2021-03-17 04:09:21 +00:00
Commented Mar 17, 2021 at 4:09 — SANGEETH SUBRAMONIAM
– SANGEETH SUBRAMONIAM, Commented Mar 17, 2021 at 4:09

SANGEETH SUBRAMONIAM · Accepted Answer · 2021-03-17 04:25:51Z

1

For only notes in queryset :

buy_notes = BuyNotes.objects.all().filter(students__user = request.user).values('note')

edited Mar 17, 2021 at 4:25

answered Mar 17, 2021 at 4:06

SANGEETH SUBRAMONIAM

1,0741 gold badge9 silver badges11 bronze badges

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

1 Comment

SANGEETH SUBRAMONIAM Over a year ago

if you want only note then , buy_notes = BuyNotes.objects.all().filter(students__user = request.user).values('note')

Collectives™ on Stack Overflow

how to get nested objects in django

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related