django xadmin 错误：related Field has invalid lookup: icontains

错误提示：related Field has invalid lookup: icontains 

 问题：设置查询某表的字段为‘外键字段名’

分析：设置某表的查询字段应该是相关联的明确一个字段，而不是一张表

解决方法：将查询字段设为 '外键字段名__关联表的具体字段名'

具体实例如下：

models.py

from django.db import models

class Medicines(models.Model):
    id = models.IntegerField(primary_key=True,verbose_name='药品编号')
    name = models.CharField(max_length=50, null=False, verbose_name='药品名称')
    mode = models.CharField(max_length=20,null=True, verbose_name='药品类型')
    efficacy = models.CharField(max_length=100, null=True, verbose_name='药品功效')
    
    class Meta:
        db_table = 'tb_medicines'
        verbose_name = '药品信息'
        verbose_name_plural = verbose_name
    def __str__(self):
        
        return '%s' %( self.name)

    
class SKU(models.Model):
    medicine = models.ForeignKey(Medicines, on_delete=models.CASCADE, verbose_name='商品')
    price = models.DecimalField(max_digits=10, decimal_places=2, verbose_name='单价')
    cost_price = models.DecimalField(max_digits=10, decimal_places=2, verbose_name='进价')
    market_price = models.DecimalField(max_digits=10, decimal_places=2, verbose_name='市场价')
    stock = models.IntegerField(default=0, verbose_name='库存')
    sales = models.IntegerField(default=0, verbose_name='销量')
    date = models.DateField(auto_now=True, verbose_name='日期')


    class Meta:
        db_table = 'tb_sku'
        verbose_name = '药品库存'
        verbose_name_plural = verbose_name

    def __str__(self):
        # return '%d-%d-%d-%d-%d-%d' % (self.id, self.price, self.cost_price, self.market_price, self.stock, self.sales)
        return '%s' % (self.medicine.name)

adminx.py

import xadmin
from medicines import models

class SKUAdmin(object):
    model_icon = 'fa fa-gift'
    list_display = ['medicine', 'price', 'cost_price', 'market_price', 'stock', 'sales','date']
      # 指定要搜索的字段
    list_filter = ['medicine','date']  # 指定过滤字段
    list_export = ['xls']
    refresh_times = [3, 5]  # 可选以支持按多长时间(秒)刷新页面
    data_charts = {
        "medicine_sales": {'title': '药品销量', "x-field": "date", "y-field": ('sales',),
                           "order": ('date',)},
        "medicine_market_price": {'title': '市场价', "x-field": "date", "y-field": ('market_price',),
                        "order": ('date',)},
        "medicine_price": {'title': '单价', "x-field": "date", "y-field": ('price',),
                        "order": ('date',)},
        "medicine_cost_price": {'title': '进价', "x-field": "date", "y-field": ('cost_price',),
                                  "order": ('date',)},
    }


xadmin.site.register(models.SKU, SKUAdmin)

 其中SKU表的medicine为外键字段关联Medicines表

SKU表想要根据关联表Medicines的name字段查询

正确设置为‘search_fields = ['medicine__name']’，即‘关联表字段名__关联表查询字段’

 

问题解决，大功告成