如何在Django的object.filter()中实现多类别列表筛选？

加载页面时只有queryset2能输出对应类别的帖子，符合预期，但queryset和queryset1无法筛选出目标帖子，原因如下：

代码参考 #

models.py #

class Post(models.Model):
    ANALYSIS = "Analysis"
    MILESTONE = "Milestone"
    FEATURES = "Features"
    TUTORIALS = "Tutorials"
    CAREERS = "Careers"
    COMMUNITY = "Community"

    CATEGORY_CHOICES = [
        (ANALYSIS, 'Analysis'),
        (MILESTONE, "Milestone"),
        (FEATURES, "Features"),
        (TUTORIALS, "Tutorials"),
        (CAREERS, "Careers"),
        (COMMUNITY, "Community"),
    ]

    user = models.ForeignKey(User, on_delete=models.CASCADE)
    title = models.CharField(max_length=125)
    body = RichTextUploadingField(blank=True, null=True)
    category = models.CharField(
        max_length=20, choices=CATEGORY_CHOICES, default="watchlist"
    )

views.py #

class BlogFilterView(LoginRequiredMixin, FilterListViewDate):
    model = Post
    filterset_class = PostFilter
    template_name = "dashboard/blog_filter.html"
    paginate_by = 5

    def get_queryset(self):
        # categories = ["ANALYSIS", "MILESTONE", "FEATURES", "TUTORIALS", "CAREERS", "COMMUNITY",]
        categories = ["Analysis", "Milestone", "Features", "Tutorials", "Careers", "Community",]
        queryset = Post.objects.filter(category__icontains=categories)
        print("queryset =", queryset)
        queryset1 = Post.objects.filter(category__icontains="Analysis").filter(category__icontains="Milestone") \
        .filter(category__icontains="Features").filter(category__icontains="Tutorials") \
        .filter(category__icontains="Careers").filter(category__icontains="Community")
        print("queryset1 =", queryset1)
        queryset2 = Post.objects.filter(category__icontains="Community")
        print("queryset2 =", queryset2)

        return queryset

原因分析 #

1. queryset失效原因：
   category__icontains 仅接收单个字符串作为参数，你传入列表categories时，Django会将整个列表转为字符串进行模糊匹配（相当于查找category包含"['Analysis', 'Milestone', ...]"的记录），显然不存在这类数据，因此queryset返回空结果。

2. queryset1失效原因：
   连续调用.filter()会生成AND逻辑的查询条件，要求一条帖子的category同时包含"Analysis"、"Milestone"、"Features"等所有关键词，但你的category字段是单一分类（比如仅为"Community"或"Analysis"），不可能同时满足所有模糊匹配条件，因此queryset1也返回空结果。

解决方法 #

如果要筛选出所有属于指定分类列表的帖子，建议使用__in查询（精确匹配列表中的任意值），这更符合你的业务场景（category是固定选项，无需模糊匹配）：

queryset = Post.objects.filter(category__in=categories)

如果确实需要模糊匹配（比如category字段可能包含多个关键词），可以用Q对象实现OR逻辑：

from django.db.models import Q

query = Q()
for cat in categories:
    query |= Q(category__icontains=cat)
queryset = Post.objects.filter(query)

内容的提问来源于stack exchange，提问作者Alex Winkler