如何获得查询结果的另一个查询在Django

Question

我有以下型号：

class Activity(models.Model): 
    name = models.CharField(max_length=128) 
    def __unicode__(self): 
     return self.name 

class CustomerActivity(models.Model): 
    customer = models.ForeignKey(Customer) 
    activity = models.ForeignKey(Activity) 
    def __unicode__(self): 
     return self.activity.name 

我有一个过滤器，得到了客户的所有CustomerActivities：

customer_activities = CustomerActivity.objects.filter(customer=customer) 

我真的需求是基于customer_activities结果的所有Activity对象吗？

喜欢的东西

activities = Activity.objects.filter(activity_in=customer_activities)??? 

Answer 1

试试这个

activities = Activity.objects.filter(customeractivity__customer=customer) 

了解更多关于lookups that span relationships