Django中使用Prefetch指定to_attr后调用values()出现FieldError问题咨询

Hey there, let's break down why you're seeing this FieldError and walk through how to fix it.

问题根源 #

The key issue here is the mismatch between how Prefetch with to_attr works and what the values() method can handle:

• When you use Prefetch(..., to_attr="products_bis"), you're creating a Python-level attribute on your Category objects. Django loads the filtered Product data into this attribute after the initial database query finishes—it's not a database field, nor is it a model-defined relationship that the ORM can recognize during SQL generation.
• The values() method translates directly to a SQL SELECT statement, which only works with actual database fields or model relationships (like the products ManyToMany field defined on Category). Since products_bis doesn't exist in the database or model schema, Django throws the "Cannot resolve keyword" error.

解决方法 #

Depending on your end goal, here are a few practical approaches to fix this:

1. 从Product模型反向查询（推荐，更高效） #

If your main goal is to get the primary keys of Products that belong to any Category and have effective_stock > 0, querying directly from Product is cleaner and more efficient—all filtering happens at the database level:

# 导入你用来计算effective_stock的函数/表达式
from django.db.models import ...

product_pks = Product.objects.filter(
    categories__isnull=False,  # 可选：如果要指定特定Category，改成categories__slug="your-target-slug"
    effective_stock__gt=0
).annotate(effective_stock=...).values_list('pk', flat=True)

This gives you a flat list of all matching Product IDs directly.

2. 在Python层面提取数据（适合小数据量场景） #

If you need to work with Category objects first, you can fetch them with the preloaded products_bis, then extract the IDs in Python:

categories = Category.objects.prefetch_related(
    Prefetch(
        "products",
        queryset=Product.objects.all().annotate(effective_stock=...).filter(effective_stock__gt=0),
        to_attr="products_bis"
    )
).all()

# 提取所有符合条件的Product主键
product_pks = []
for category in categories:
    product_pks.extend([prod.pk for prod in category.products_bis])

# 去重（如果同一个Product属于多个Category）
product_pks = list(set(product_pks))

This loads all relevant data into memory first, so it's best for smaller datasets.

3. 用数据库层面的子查询实现 #

If you want to keep the query centered on Category but still do all work at the database level, use a subquery with Exists:

from django.db.models import Exists, OuterRef

# 定义子查询：筛选当前Category下effective_stock>0的Product
valid_product_subquery = Product.objects.filter(
    categories=OuterRef('pk'),
    effective_stock__gt=0
).annotate(effective_stock=...)

# 获取有有效Product的Category，然后关联获取Product IDs
category_products = Category.objects.filter(
    Exists(valid_product_subquery)
).values('products__pk').distinct()

# 转为扁平列表
product_pks = category_products.values_list('products__pk', flat=True)

This keeps all logic in SQL, making it efficient for large datasets.

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