django 如何过滤某个分类下的文章

    def __str__(self):
        return self.name

class article(models.Model):
    title = models.CharField(u'标题', max_length=60)
    category = models.ForeignKey(Category, verbose_name=u'标签', max_length=10, null=True)

在 url 中以分类名作为参数传递给 views 内函数进行过滤行不通

def Category_list(request, category):
    try:
        category_post = article.objects.filter(category_iexact=category)
    except article.DoesNotExist:
        raise Http404
    return render(request, 'category.html', {"category_post": category_post})

ValueError at /linux/ invalid literal for int() with base 10: 'linux'

8 replies • 2016-11-21 12:01:58 +08:00

unsuey

Nov 3, 2016

```python
def Category_list(request, category):
try:
category_post = article.objects.filter(category__name__iexact=category)
except article.DoesNotExist:
raise Http404
return render(request, 'category.html', {"category_post": category_post})
```

lovebeyondalways

Nov 3, 2016

@Blunt1991 谢谢大牛此法可用

lovebeyondalways

Nov 3, 2016

@Blunt1991
敢问大神__name __iexact 这两个字段在哪篇文档里有详解

sherwinkoo

Nov 3, 2016

@lovebeyondalways https://docs.djangoproject.com/el/1.10/ref/models/querysets/#id4

unsuey

Nov 3, 2016

官方文档， https://docs.djangoproject.com/en/1.10/topics/db/queries/#lookups-that-span-relationships
你原来的代码中 category_iexact 查询时其实是根据 id 去查询的，要根据 model 的其他属性去查询的话，直接双下划线就属性就可以了。

lovebeyondalways

Nov 3, 2016 via Android

原来是这样，看来官方文档要过一遍

zmrenwu

Nov 5, 2016

category_post = article.objects.filter(category=category)

或者 category_post = category.article_set.all()

Ellen

Nov 21, 2016

传过来的参数是字符串，这里 iexact 的需要是一个 category 对象。