擅长:python、mysql、java
<p>在exclude或filter参数中放置的查找在解析为SQL语句时被AND。因此,在您上次的查询中,您正在这样做(用英语):</p>
<blockquote>
<p>Give me all the MessageThread objects that have a message with "p2" as recipient and from those objects, quit all messages that have "deleted" as status and "p2" as a recipient.</p>
</blockquote>
<p>所以基本上,你排除了你过滤的东西。如果要获取所有未删除的收件人为“p2”的邮件,可以执行以下操作:</p>
<p><strong>编辑</strong>好的,现在我知道你需要什么了。所以你基本上只需要你的问题的排除部分。我想你需要这个:</p>
<pre><code>MessageThread.objects.exclude(message__status='deleted', message__recipient_id=4)
</code></pre>