model,admin,table如下service页面查询host时出错related Field has invalid lookup: icontains

table:

CREATE TABLE `host` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `cmdb_sn` varchar(32) NOT NULL,  `internal_ip` varchar(16) NOT NULL,  `external_ip` varchar(16) NOT NULL,  `idc_name` varchar(16) NOT NULL,  `status` enum('online','unused','repair') DEFAULT 'unused',  `description` varchar(32) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8CREATE TABLE `service` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `host_id` int(11) unsigned NOT NULL,  `port` int(10) unsigned NOT NULL,....  PRIMARY KEY (`id`),  UNIQUE KEY `host_id` (`host_id`,`port`),) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1

?

model:

class Host(models.Model):#    id=models.IntegerField(max_length=10)    cmdb_sn= models.CharField(max_length=32)    internal_ip= models.CharField(max_length=16)    external_ip= models.CharField(max_length=16)    idc_name= models.CharField(max_length=16)    status = models.IntegerField(max_length=10)    description = models.CharField(max_length=32)    def __unicode__(self):         return '%s' %(self.internal_ip)    class Meta:        db_table = 'host'        ordering=['internal_ip'] class Service(models.Model):    host = models.ForeignKey(Host)    port= models.IntegerField(max_length=10)    role= models.IntegerField(max_length=10)    status= models.IntegerField(max_length=10)    description = models.CharField(max_length=32)    def __unicode__(self):         return '%s id:%s host:%s' %(self.port,self.id,self.host)    class Meta:        db_table = 'service'        ordering=['port']admin:class ServiceAdmin(admin.ModelAdmin):    list_display = ('port', 'host','role','status','description')    search_fields = ('id','port', 'host,'role','status') 

?

service页面查询host时出错related Field has invalid lookup: icontains

改?search_fields =('id','port', 'host__internal_ip','role','status')?ok~

class ServiceAdmin(admin.ModelAdmin):
??? list_display = ('port', 'host','role','status','description')

??? search_fields = ('id','port', 'host__internal_ip','role','status')

?

Related Field has invalid lookup: icontains。
原来外键查询是需要指定相应的字段的。外键不只是一个model，而该是另一个表的明确的一个字段。
所以我们需要指定特定的字段 "本表外键字段__外键所在表需查询字段"

参考：http://code.djangoproject.com/ticket/2331

?

Closing as Ian stated it was an error on his part. Ian: If there's still a problem with Django that needs to be fixed, please reopen.

comment:6Changed?21 months?ago by AntonBessonov

This error raised if use search_fields in admin.py. E.x:

class AnotherModel(models.Model):txt = models.CharField(_('Text'), max_length=255)??class MyModel(models.Model):prop = models.ForeignKey(AnotherModel)

You must use:

class MyModelAdmin(admin.ModelAdmin):search_fields = ('prop__txt')

Maybe must raise properly exception?

转自：http://hi.baidu.com/%C3%CE%C0%EF%CF%E3%B0%CD%C0%AD/blog/item/2f93659050f9d799a877a4c6.html