Django显示外键名称而不是外键ID

Question

如何显示查询中外键的名称？

class Books (models.Models) 
    category = models.ForeignKey(Category) 
    user = models.ForeignKey(User) 
    amount = models.DecimalField(max_digits=15, decimal_places=2) 

class Category(models.Models) 
    name = models.CharField(max_length=30) 

def list_books_totalamount_by_category(request): 
    context = Books.objects.filter(user=4).values('category').annotate(amount2=Sum('amount')) 
    return render(request, 'test.html', {'context':context} 

如何使查询显示类别名称而不是category_id？

谢谢

Answer 1

Books.objects.filter(user=4).values('category__name').annotate(amount2=Sum('amount'))