CODEWITHSUNDEEP
django
user2954587
user2954587

Reputation: 4861

Django group by foreign key id

How can I group a query Qualifications and group them by quote__uuid? I looked into aggregation but doesn't seem to fit my need.

My ideal output is [{'quote_uuid_1':[qualification_1, qualification_2], 'quote_uuid_2':[qualification_3] }]

class Quote
   uuid = models.CharField()

class Qualification
   quote = models.ForeignKey(Quote)

Upvotes: 2

Views: 887

Answers (1)

Anush Devendra
Anush Devendra

Reputation: 5475

try:

result = [{quote.id:quote.qualification_set.all()} for quote in Quote.objects.all()]

Upvotes: 1

Related Questions