我有以下模式
class Command(models.Model): server = models.ForeignKey(Server) user_login = models.CharField(max_length=100) user_run = models.CharField(max_length=100) host = models.CharField(max_length=100) ip = models.CharField(max_length=100) session = models.CharField(max_length=100) command = models.TextField() ts = models.DateTimeField(auto_now_add=True) version = models.CharField(max_length=100) type = models.CharField(max_length=100)
cmds = Command.objects.filter(Q(user_login__contains=form.cleaned_data['loguser']),Q(user_run__contains=form.cleaned_data['runuser']),Q(host__contains=form.cleaned_data['loghost']),Q(command__contains=form.cleaned_data['command']),Q(server__contains=form.cleaned_data['host']),Q(session__contains=form.cleaned_data['session'])) \ .order_by('-id')[:100]
我需要通过以下字符串搜索server.host
Q(server__contains=form.cleaned_data['host']),Exception Type: TypeError Exception Value: Related Field has invalid lookup: contains Exception Location: /usr/lib/python2.5/site-packages/django/db/models/fields/related.py in get_db_prep_lookup,line 156
form.cleaned_data [‘host’]将包含一个主机名的文本字符串.
解决方法
server__searchfieldname__contains
您没有指定服务器表中的哪个字段应该查找.