首页 > 解决方案 > django-filter 根据数据库列的年份过滤

问题描述

我在数据库中有一个列(dob)作为日期。我如何过滤它的年份?

class PersonFilter(django_filters.FilterSet):
    class Meta:
        model = Person
        fields =  ['first_name','last_name','dob',]

标签: djangodjango-filter

解决方案


在那里找到了答案: https ://django-filter.readthedocs.io/en/master/guide/usage.html#declaring-filters

class PersonFilter(django_filters.FilterSet):

    dob_year = django_filters.NumberFilter(field_name='dob', lookup_expr='year')

    class Meta:
        model = Person
        fields =  ['first_name','last_name','dob',]

推荐阅读