blocks|key|1560334|text|请参阅docs|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1560335|>>>+Blog.objects.in_bulk([1])
{1:+<Blog:+Beatles+Blog>}
>>>+Blog.objects.in_bulk([1,+2])
{1:+<Blog:+Beatles+Blog>,+2:+<Blog:+Cheddar+Talk>}
>>>+Blog.objects.in_bulk([])
{}|code-block|syntax|javascript|1560336|请注意，此方法仅适用于主键查找，但这似乎正是您要尝试做的事情。|1560337|所以你想要的是：|1560338|Article.objects.in_bulk([1,+2,+3])|1560339|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.djangoproject.com/en/dev/ref/models/querysets/#in-bulk-id-list^0|3|4|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|N|5|F|7|13|8|@]|9|@]|C|$G|H]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

See the <a href="http://docs.djangoproject.com/en/dev/ref/models/querysets/#in-bulk-id-list" rel="noreferrer">docs</a>:

<pre><code>&gt;&gt;&gt; Blog.objects.in_bulk([1])
{1: &lt;Blog: Beatles Blog&gt;}
&gt;&gt;&gt; Blog.objects.in_bulk([1, 2])
{1: &lt;Blog: Beatles Blog&gt;, 2: &lt;Blog: Cheddar Talk&gt;}
&gt;&gt;&gt; Blog.objects.in_bulk([])
{}
</code></pre>

Note that this method only works for primary key lookups, but that seems to be what you're trying to do.

So what you want is:

<pre><code>Article.objects.in_bulk([1, 2, 3])
</code></pre>

blocks|key|1560402|text|您可以使用%7C=操作符通过Q对象以编程方式更新查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1560403|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can use the |= operator to programmatically update a query using Q objects.

blocks|key|1560455|text|也许使用sql+IN语句会更好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1560456|Article.objects.filter(id__in=[1,+2,+3])|code-block|syntax|javascript|1560457|参见queryset+api+reference。|offset|length|1560458|如果你真的需要使用动态逻辑进行查询，你可以这样做(丑陋%2B未测试)：|1560459|query+=+Q(field=1)
for+cond+in+(2,+3):
++++query+=+query+%7C+Q(field=cond)
Article.objects.filter(query)|1560460|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.djangoproject.com/en/1.0/ref/models/querysets/#in^0|0|0|2|M|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

Maybe it's better to use sql IN statement.

<pre><code>Article.objects.filter(id__in=[1, 2, 3])
</code></pre>

See <a href="http://docs.djangoproject.com/en/1.0/ref/models/querysets/#in" rel="noreferrer">queryset api reference</a>.

If you really need to make queries with dynamic logic, you can do something like this (ugly + not tested):

<pre><code>query = Q(field=1)
for cond in (2, 3):
 query = query | Q(field=cond)
Article.objects.filter(query)
</code></pre>

blocks|key|1344991|text|您可以按如下方式链接您的查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1344992|values+=+[1,2,3]

#+Turn+list+of+values+into+list+of+Q+objects
queries+=+[Q(pk=value)+for+value+in+values]

#+Take+one+Q+object+from+the+list
query+=+queries.pop()

#+Or+the+Q+object+with+the+ones+remaining+in+the+list
for+item+in+queries:
++++query+%7C=+item

#+Query+the+model
Article.objects.filter(query)|code-block|syntax|javascript|1344993|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You could chain your queries as follows:

<pre><code>values = [1,2,3]

# Turn list of values into list of Q objects
queries = [Q(pk=value) for value in values]

# Take one Q object from the list
query = queries.pop()

# Or the Q object with the ones remaining in the list
for item in queries:
 query |= item

# Query the model
Article.objects.filter(query)
</code></pre>

blocks|key|1560517|text|使用python's+reduce+function编写Dave+Webb答案的一种更简单的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1560518|#+For+Python+3+only
from+functools+import+reduce

values+=+[1,2,3]

#+Turn+list+of+values+into+one+big+Q+objects++
query+=+reduce(lambda+q,value:+q%7CQ(pk=value),+values,+Q())++

#+Query+the+model++
Article.objects.filter(query)++|code-block|syntax|javascript|1560519|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.python.org/library/functions.html#reduce^0|2|O|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

A shorter way of writing Dave Webb's answer using <a href="http://docs.python.org/library/functions.html#reduce" rel="noreferrer">python's reduce function</a>:

<pre><code># For Python 3 only
from functools import reduce

values = [1,2,3]

# Turn list of values into one big Q objects 
query = reduce(lambda q,value: q|Q(pk=value), values, Q()) 

# Query the model 
Article.objects.filter(query) 
</code></pre>

blocks|key|1345009|text|from+functools+import+reduce
from+operator+import+or_
from+django.db.models+import+Q

values+=+[1,+2,+3]
query+=+reduce(or_,+(Q(pk=x)+for+x+in+values))|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1345010|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>from functools import reduce
from operator import or_
from django.db.models import Q

values = [1, 2, 3]
query = reduce(or_, (Q(pk=x) for x in values))
</code></pre>

blocks|key|1345023|text|如果我们想要以编程方式设置要查询的数据库字段：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1345024|import+operator
questions+=+[('question__contains',+'test'),+('question__gt',+23+)]
q_list+=+[Q(x)+for+x+in+questions]
Poll.objects.filter(reduce(operator.or_,+q_list))|code-block|syntax|javascript|1345025|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In case we want to programmatically set what db field we want to query: 

<pre><code>import operator
questions = [('question__contains', 'test'), ('question__gt', 23 )]
q_list = [Q(x) for x in questions]
Poll.objects.filter(reduce(operator.or_, q_list))
</code></pre>

blocks|key|1345043|text|这个是针对动态主键列表的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1345044|pk_list+=+qs.values_list('pk',+flat=True)++#+i.e+[]+or+[1,+2,+3]

if+len(pk_list)+==+0:
++++Article.objects.none()

else:
++++q+=+None
++++for+pk+in+pk_list:
++++++++if+q+is+None:
++++++++++++q+=+Q(pk=pk)
++++++++else:
++++++++++++q+=+q+%7C+Q(pk=pk)

++++Article.objects.filter(q)|code-block|syntax|javascript|1345045|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This one is for dynamic pk list:

<pre><code>pk_list = qs.values_list('pk', flat=True) # i.e [] or [1, 2, 3]

if len(pk_list) == 0:
 Article.objects.none()

else:
 q = None
 for pk in pk_list:
 if q is None:
 q = Q(pk=pk)
 else:
 q = q | Q(pk=pk)

 Article.objects.filter(q)
</code></pre>

blocks|key|1560620|text|要构建更复杂的查询，还可以选择使用内置Q()对象的常量Q.OR和Q.AND以及add()方法，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1560621|list+=+[1,+2,+3]
#+it+gets+a+bit+more+complicated+if+we+want+to+dynamically+build
#+OR+queries+with+dynamic/unknown+db+field+keys,+let's+say+with+a+list
#+of+db+fields+that+can+change+like+the+following
#+list_with_strings+=+['dbfield1',+'dbfield2',+'dbfield3']

#+init+our+q+objects+variable+to+use+.add()+on+it
q_objects+=+Q(id__in=[])

#+loop+trough+the+list+and+create+an+OR+condition+for+each+item
for+item+in+list:
++++q_objects.add(Q(pk=item),+Q.OR)
++++#+for+our+list_with_strings+we+can+do+the+following
++++#+q_objects.add(Q(**{item:+1}),+Q.OR)

queryset+=+Article.objects.filter(q_objects)

#+sometimes+the+following+is+helpful+for+debugging+(returns+the+SQL+statement)
#+print+queryset.query|code-block|syntax|javascript|1560622|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To build more complex queries there is also the option to use built in Q() object's constants Q.OR and Q.AND together with the add() method like so:

<pre><code>list = [1, 2, 3]
# it gets a bit more complicated if we want to dynamically build
# OR queries with dynamic/unknown db field keys, let's say with a list
# of db fields that can change like the following
# list_with_strings = ['dbfield1', 'dbfield2', 'dbfield3']

# init our q objects variable to use .add() on it
q_objects = Q(id__in=[])

# loop trough the list and create an OR condition for each item
for item in list:
 q_objects.add(Q(pk=item), Q.OR)
 # for our list_with_strings we can do the following
 # q_objects.add(Q(**{item: 1}), Q.OR)

queryset = Article.objects.filter(q_objects)

# sometimes the following is helpful for debugging (returns the SQL statement)
# print queryset.query
</code></pre>

blocks|key|1345084|text|简单..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1345085|+from+django.db.models+import+Q+++++import+you+model+++++args+=+(Q(visibility=1)%7C(Q(visibility=0)&Q(user=self.user)))++#Tuple+++++parameters={}++#dic++++++order+=+'create\_at'++++++limit+=+10|code-block|syntax|javascript|1345086|Models.objects.filter(*args,**parameters).order_by(order)[:limit]|1345087|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|D|7|M|8|@]|9|@]|A|$E|F]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

easy.. 
 from django.db.models import Q
 import you model
 args = (Q(visibility=1)|(Q(visibility=0)&amp;Q(user=self.user))) #Tuple
 parameters={} #dic 
 order = 'create_at' 
 limit = 10

<pre><code>Models.objects.filter(*args,**parameters).order_by(order)[:limit]
</code></pre>

blocks|key|1345116|text|另一个我直到最近才意识到的选择-+QuerySet也覆盖了&，%7C，~等运算符。其他的答案是OR+Q对象是这个问题的更好的解决方案，但是出于兴趣/争论的原因，你可以这样做：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1345117|id_list+=+[1,+2,+3]
q+=+Article.objects.filter(pk=id_list[0])
for+i+in+id_list[1:]:
++++q+%7C=+Article.objects.filter(pk=i)|code-block|syntax|javascript|1345118|str(q.query)将返回一个查询，其中包含WHERE子句中的所有过滤器。|1345119|entityMap^0|H|8|T|1|V|1|X|1|0|0|0|C|O|5|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|N|$]]

Another option I wasn't aware of until recently - <code>QuerySet</code> also overrides the <code>&amp;</code>, <code>|</code>, <code>~</code>, etc, operators. The other answers that OR Q objects are a better solution to this question, but for the sake of interest/argument, you can do:

<pre><code>id_list = [1, 2, 3]
q = Article.objects.filter(pk=id_list[0])
for i in id_list[1:]:
 q |= Article.objects.filter(pk=i)
</code></pre>

<code>str(q.query)</code> will return one query with all the filters in the <code>WHERE</code> clause.

blocks|key|1560723|text|使用reduce和or_运算符按多个字段进行过滤解决方案。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1560724|from+functools+import+reduce
from+operator+import+or_
from+django.db.models+import+Q

filters+=+{'field1':+[1,+2],+'field2':+['value',+'other_value']}

qs+=+Article.objects.filter(
+++reduce(or_,+(Q(**{f'{k}__in':+v})+for+k,+v+in+filters.items()))
)|code-block|syntax|javascript|1560725|附注：f是一种新的格式字符串文字。它是在python+3.6中引入的|1560726|entityMap^0|2|6|9|3|0|0|3|1|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

Solution which use <code>reduce</code> and <code>or_</code> operators to filter by multiply fields. 

<pre><code>from functools import reduce
from operator import or_
from django.db.models import Q

filters = {'field1': [1, 2], 'field2': ['value', 'other_value']}

qs = Article.objects.filter(
 reduce(or_, (Q(**{f'{k}__in': v}) for k, v in filters.items()))
)
</code></pre>

p.s. <code>f</code> is a new format strings literal. It was introduced in python 3.6

From an example you can see a multiple OR query filter:

<pre><code>Article.objects.filter(Q(pk=1) | Q(pk=2) | Q(pk=3))
</code></pre>

For example, this results in:

<pre><code>[&lt;Article: Hello&gt;, &lt;Article: Goodbye&gt;, &lt;Article: Hello and goodbye&gt;]
</code></pre>

However, I want to create this query filter from a list. How to do that?

e.g. <code>[1, 2, 3] -&gt; Article.objects.filter(Q(pk=1) | Q(pk=2) | Q(pk=3))</code>

How to dynamically compose an OR query filter in Django?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

从一个示例中，您可以看到一个多OR查询过滤器：Article.objects.filter(Q(pk=1) | Q(pk=2) | Q(pk=3))例如，这将导致：[<Article: Hello>, <Article: Goodbye>, <Article: Hello and goodbye>]但是，我希望从列表创...

问如何在Django中动态编写OR查询过滤器？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django中动态编写OR查询过滤器？EN