Django的注释计数错误（可能重复？）

Question

我有一个模型chatmessage具有字段发件人，它是foreferkey to user模型。

我正在尝试注释所有尚未读取的所有chatmessage对象（例如，seaw_at__isnull = true）。

对于给定的用户，只有一条发送的消息，sead_at__isnull = true，但django返回11。

User.objects.select_related(...).annotate(
            sent_unread_messages=Count('sent_chat_messages',
                                       filter=Q(sent_chat_messages__seen_at__isnull=True))).get(pk=1234).sent_unread_messages

您知道问题在哪里吗？

编辑：

class ChatMessageManager(models.Manager):
    def get_queryset(self) -> models.QuerySet:
        return super().get_queryset().select_related('sender', 'recipient')

    def as_sender_or_recipient(self, user) -> models.QuerySet:
        return self.get_queryset().filter(Q(sender=user) | Q(recipient=user))

class ChatMessage(BaseModel):
    objects = ChatMessageManager()
    sender = models.ForeignKey('users.User', verbose_name='Odosielateľ', null=True, blank=True,
                               on_delete=models.SET_NULL, related_name='sent_chat_messages')

    recipient = models.ForeignKey('users.User', verbose_name='Adresát', null=True, blank=True,
                                  on_delete=models.SET_NULL, related_name='received_chat_messages')

    content = models.TextField('Obsah')
    attachment = models.FileField('Príloha', null=True, blank=True)
    attachment_filename = models.CharField('Názov prílohy', null=True, blank=True, max_length=128)
    meta = models.JSONField(verbose_name='Meta', null=True, blank=True, help_text='must be JSON')
    seen_at = models.DateTimeField('Prečítané o', null=True, blank=True)



class CustomUserManager(UserManager):
    def get_queryset(self):
        return super().get_queryset().select_related('staff_profile', 'client_profile').annotate(
            sent_unread_messages=Count('sent_chat_messages',
                                       filter=Q(sent_chat_messages__seen_at__isnull=True))).annotate(
            received_unread_messages=Count('received_chat_messages',
                                           filter=Q(received_chat_messages__seen_at__isnull=True))).annotate(
            sent_latest_message=Subquery(
                ChatMessage.objects.filter(sender=OuterRef('pk')).order_by('-created').values('content')[:1])).annotate(
            sent_latest_message_dt=Subquery(
                ChatMessage.objects.filter(sender=OuterRef('pk')).order_by('-created').values('created')[:1])).annotate(
            received_latest_message=Subquery(
                ChatMessage.objects.filter(recipient=OuterRef('pk')).order_by('-created').values('content')[
                :1])).annotate(
            received_latest_message_dt=Subquery(
                ChatMessage.objects.filter(recipient=OuterRef('pk')).order_by('-created').values('created')[:1]))

Answer 1

您可以尝试使用.distinct（）方法（在获取消息时从QuerySet中删除重复元素）吗？