blocks|key|4333605|text|重写ModelAdmin的get_search_results方法以使用所需的查询。您可以在为自动补全字段提供数据的视图的get_queryset方法中看到，该方法用于获取查询集-此答案的源是https://github.com/django/django/blob/03dbdfd9bbbbd0b0172aad648c6bbe3f39541137/django/contrib/admin/views/autocomplete.py#L42。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4333606|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/2.0/ref/contrib/admin/#django.contrib.admin.ModelAdmin.get_search_results|1|https://github.com/django/django/blob/03dbdfd9bbbbd0b0172aad648c6bbe3f39541137/django/contrib/admin/views/autocomplete.py#L42^0|D|I|1P|C|D|I|0|2O|3H|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]|$9|X|A|Y|1|Z]]|E|$]]|$1|F|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]|N|$5|I|J|K|E|$L|O]]]]

Override the ModelAdmin's <a href="https://docs.djangoproject.com/en/2.0/ref/contrib/admin/#django.contrib.admin.ModelAdmin.get_search_results" rel="noreferrer"><code>get_search_results</code></a> method to use the query you want. You can see in the <code>get_queryset</code> method for the view providing the data for autocomplete fields that it's used to get the queryset - the source as of this answer is <a href="https://github.com/django/django/blob/03dbdfd9bbbbd0b0172aad648c6bbe3f39541137/django/contrib/admin/views/autocomplete.py#L42" rel="noreferrer">https://github.com/django/django/blob/03dbdfd9bbbbd0b0172aad648c6bbe3f39541137/django/contrib/admin/views/autocomplete.py#L42</a>.

blocks|key|4333663|text|如果对'self‘上的ManyToManyField使用autocomplete_fields，则此示例将排除当前对象。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4333664|通过重写get_form获取当前对象的id|4333665|field_for_autocomplete+=+None

def+get_form(self,+request,+obj=None,+**kwargs):
++++if+obj:
++++++++self.field_for_autocomplete+=+obj.pk

++++return+super(MyAdmin,+self).get_form(request,+obj,+**kwargs)|code-block|syntax|javascript|4333666|接下来，覆盖get_search_results。仅为模型的自动完成URI修改查询集：|4333667|def+get_search_results(self,+request,+queryset,+search_term):
++++queryset,+use_distinct+=+super().get_search_results(request,+queryset,+search_term)

++++#+Exclude+only+for+autocomplete
++++if+request.path+==+'/admin/myapp/mymodel/autocomplete/':
++++++++queryset+=+queryset.exclude(field=self.field_for_autocomplete)

++++return+queryset,+use_distinct|4333668|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/27304574/3473496^0|B|F|S|J|0|4|8|4|8|0|0|0|6|I|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@$9|16|A|17|1|18]]|E|$]]|$1|H|3|I|5|J|7|19|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|1D|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

If you are using <code>autocomplete_fields</code> for a <code>ManyToManyField</code> on 'self',
this example will exclude the current object.

Get the current object's id by overriding <a href="https://stackoverflow.com/a/27304574/3473496"><code>get_form</code></a>:

<pre><code>field_for_autocomplete = None

def get_form(self, request, obj=None, **kwargs):
 if obj:
 self.field_for_autocomplete = obj.pk

 return super(MyAdmin, self).get_form(request, obj, **kwargs)
</code></pre>

Next, override <code>get_search_results</code>. Modify the queryset only for your model's autocomplete URI:

<pre><code>def get_search_results(self, request, queryset, search_term):
 queryset, use_distinct = super().get_search_results(request, queryset, search_term)

 # Exclude only for autocomplete
 if request.path == '/admin/myapp/mymodel/autocomplete/':
 queryset = queryset.exclude(field=self.field_for_autocomplete)

 return queryset, use_distinct
</code></pre>

blocks|key|4333398|text|不知何故，我遇到了同样的问题，当我使用autocomplete_fields时，limit_choices_to没有生效，然后我为我的情况找到了一个解决方案，可能也会对其他人有帮助。这是我的一个想法和解决方案，任何人都应该为他/她的使用而更改代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4333399|假设我们有两个模型model_A和modle_B:我们将覆盖"get_search_results“|4333400|model_A的模型管理(因为model_B有一个foreign_key(或m2m)+)，在我的例子中，我只想将选择限制到所有model_A对象，这些对象|4333401|当前没有model_B连接的对象，或者在将model_B对象更新为仅前一个model_A对象的情况下。所以我们就去|4333402|#+moodels.py
class+model_A(models.Model):
++++name+=+models.CharField()

class+model_B(models.Model):
++++name+=+models.CharField()
++++fk_field+=+models.OneToOneField(+#ManyToManyField+or+ForeignKey
++++model_A,
++++related_name='fk_reverse',
++++on_delete=models.CASCADE)

#+admin.py
class+model_A_Admin(admin.ModelAdmin):
+++search_fields+=+('name',+)

+def+get_search_results(self,+request,+queryset,+search_term):
++++++++import+re
++++++++queryset,+use_distinct+=+super().get_search_results(request,+queryset,+search_term)
++++#+note:+str(request.META.get('HTTP_REFERER'))+is+the+url+from+which+the+request+had+come/previous+url.
++++++++if+"model_b/add/"+in+str(request.META.get('HTTP_REFERER')):
++++++++#+if+we+were+in+creating+new+model_B+instanse+page
++++++++#+note:+the+url+is+somehow+containing+model_Bs+calss+name+then+/+then+"add"
++++++++#+so+there+is+no+related+object(of+model_A)+for+non+exsisting+object(of+model_B)
++++++++++++queryset+=+self.model.objects.filter(fk_reverse=None)
++++++++elif+re.search(r"model_b/\d/change/",+str(request.META.get('HTTP_REFERER'))):
++++++++#+if+we+were+in+updatineg+page+of+an+exsisting+model_B+instanse
++++++++#+the+calling+page+url+contains+the+id+of+the+model_B+instanse
++++++++#+we+are+extracting+the+id+and+use+it+for+limitaion+proccess
++++++++++++pk+=+int(re.findall(r'\d%2B',+str(str(request.META.get('HTTP_REFERER')).split('/')[-3:+]))[-1])
++++++++++++queryset+=+self.model.objects.filter(fk_reverse=pk)
++++++++return+queryset,+use_distinct|code-block|syntax|javascript|4333403|https://gist.github.com/mh-firouzjaah/48dceae592d4b4275fa31d37ac77ff69|offset|length|4333404|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|1Y|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|11|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|12|8|@]|9|@$O|13|P|14|1|15]]|A|$]]|$1|Q|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|N]]]]

I had somehow the same problem, when using autocomplete_fields the limit_choices_to was not taking affect, and then I found a solution for my case which may help others too.
this an idea and a solution for my case, anybody should change the code for his/her use.
imagine we have two models model_A and modle_B:
we are going to override the &quot;get_search_results&quot; of 
model-admin of model_A(because model_B has a foreign_key(or m2m) to it)
in my case I just want to limit choices to all model_A objects which 
currentlly dont have a model_B connected object(s)
or in case of updating an object of model_B limit to just the previous model_A object(s).
so we go
<pre><code># moodels.py
class model_A(models.Model):
 name = models.CharField()

class model_B(models.Model):
 name = models.CharField()
 fk_field = models.OneToOneField( #ManyToManyField or ForeignKey
 model_A,
 related_name='fk_reverse',
 on_delete=models.CASCADE)

# admin.py
class model_A_Admin(admin.ModelAdmin):
 search_fields = ('name', )

 def get_search_results(self, request, queryset, search_term):
 import re
 queryset, use_distinct = super().get_search_results(request, queryset, search_term)
 # note: str(request.META.get('HTTP_REFERER')) is the url from which the request had come/previous url.
 if &quot;model_b/add/&quot; in str(request.META.get('HTTP_REFERER')):
 # if we were in creating new model_B instanse page
 # note: the url is somehow containing model_Bs calss name then / then &quot;add&quot;
 # so there is no related object(of model_A) for non exsisting object(of model_B)
 queryset = self.model.objects.filter(fk_reverse=None)
 elif re.search(r&quot;model_b/\d/change/&quot;, str(request.META.get('HTTP_REFERER'))):
 # if we were in updatineg page of an exsisting model_B instanse
 # the calling page url contains the id of the model_B instanse
 # we are extracting the id and use it for limitaion proccess
 pk = int(re.findall(r'\d+', str(str(request.META.get('HTTP_REFERER')).split('/')[-3: ]))[-1])
 queryset = self.model.objects.filter(fk_reverse=pk)
 return queryset, use_distinct
</code></pre>
<a href="https://gist.github.com/mh-firouzjaah/48dceae592d4b4275fa31d37ac77ff69" rel="nofollow noreferrer">https://gist.github.com/mh-firouzjaah/48dceae592d4b4275fa31d37ac77ff69</a>

In Django 2.0, <a href="https://docs.djangoproject.com/en/2.0/ref/contrib/admin/#django.contrib.admin.ModelAdmin.autocomplete_fields" rel="noreferrer">autocomplete_fields</a> was added, which is great.

Without autocomplete_fields, I can change the queryset of a ForeignKeyField using <a href="https://docs.djangoproject.com/en/2.0/ref/contrib/admin/#django.contrib.admin.ModelAdmin.formfield_for_foreignkey" rel="noreferrer">formfield_for_foreignkey</a>.

But combining the two together doesn't work - it looks like the list of options for autocomplete is dynamic and coming from a different url, instead of from the current form.

So the question is - 

How can I change the queryset in the autocomplete widget?

How to filter choices in Django2's autocomplete_fields?

在Django2.0中，添加了，这很棒。没有autocomplete_fields，我可以使用更改ForeignKeyField的查询集。但是将两者结合在一起是行不通的--看起来自动补全的选项列表是动态的，并且来自不同的url，而不是来自当前的表单。所以问题是-如何更改自动完成小部件中的查询集？

问如何在Django2的autocomplete_fields中过滤选择？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django2的autocomplete_fields中过滤选择？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django2的autocomplete_fields中过滤选择？
EN