Django admin 实现search_fields精确查询

最新推荐文章于 2024-10-24 08:47:00 发布

只对西红柿鸡蛋有感觉

最新推荐文章于 2024-10-24 08:47:00 发布

阅读量7.6k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/chaiqunxing51/article/details/82702808

本文详细介绍了在Django Admin中如何使用自定义查询方法来优化数据检索效率，通过过滤和排序功能，实现了对gift_rule_id、user_id和activity_id字段的有效搜索。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

search_fields = (u'gift_rule_id',u'user_id', u'activity_id',)

//默认的查询集合
def get_queryset(self, request):
    return super(GiftConfirmAdmin, self).get_queryset(request).all().order_by("-id")

//根据关键字进行查询集合
def get_search_results(self, request, queryset, search_term):
    queryset, use_distinct = super(GiftConfirmAdmin, self).get_search_results(request, queryset, search_term)
    try:
        search_term_as_int = int(search_term)
        queryset &= (self.model.objects.filter(gift_rule_id=search_term_as_int) |
                     self.model.objects.filter(user_id=search_term_as_int) |
                     self.model.objects.filter(activity_id=search_term))
    except:
        pass
    return queryset, use_distinct