Django Academy · 课时

使用 Q 对象进行复杂过滤

使用 AND、OR 和 NOT 组合条件

使用 Q 对象进行复杂过滤 是 CoddyKit 上的免费 Django Academy 课时。这是第 3 节课，共 4 节。你可以在下方免费阅读本课时的完整内容 — 然后在浏览器中使用内置代码编辑器和全天候 AI 导师进行实践。这是 Django Academy 学习路径的一部分，你的进度在网页和 CoddyKit 应用中同步。 Django Academy 课程共包含 4 节课。

本课时的部分内容尚未翻译，以英文显示。

Beyond Simple filter()

Stacking keyword arguments in filter always means AND. To express OR or NOT, you need a richer tool.

Meet the Q Object

A Q object wraps a condition so you can combine conditions with boolean operators inside a single query.

from django.db.models import Q

OR with the Pipe

Combine two Q objects with the pipe operator to build an OR, matching rows that satisfy either condition.

Book.objects.filter(Q(title__icontains="django") | Q(title__icontains="flask"))

AND with the Ampersand

The ampersand joins Q objects with AND, useful when you want explicit grouping rather than plain keyword stacking.

Book.objects.filter(Q(price__lt=20) & Q(in_stock=True))

Negate with the Tilde

Put a tilde in front of a Q object to express NOT, matching every row that fails the condition.

Book.objects.filter(~Q(author__name="Anon"))

Mixing Q and Keywords

You may pass Q objects and plain keyword arguments together, but every positional Q must come before any keyword.

Book.objects.filter(Q(price__lt=20) | Q(on_sale=True), in_stock=True)

Grouping with Parentheses

Wrap combined Q objects in parentheses to control precedence, just like grouping conditions in raw SQL.

Book.objects.filter((Q(a=1) | Q(b=2)) & Q(c=3))

Build Filters Dynamically

Because Q objects are values, you can build them up conditionally in Python before passing the result to filter.

q = Q(active=True)
if term:
    q &= Q(name__icontains=term)
User.objects.filter(q)

Combine Many with reduce

Need an OR across a list of terms? Fold them together with operator.or_ to produce one combined Q.

from functools import reduce
import operator
reduce(operator.or_, [Q(tag=t) for t in tags])

Still One SQL Query

However complex the logic, Django compiles your Q tree into a single WHERE clause, so there is no extra round trip.

When to Use Q

Reach for Q whenever a filter needs OR, NOT, or logic assembled at runtime; plain keywords stay fine for simple ANDs.

Quick Check

You want books whose title contains django OR flask. Which filter expresses that?

Recap

Q objects unlock OR, AND, and NOT logic you can group and build dynamically, all compiled into one query. 🧩

常见问题解答

「使用 Q 对象进行复杂过滤」课时是免费的吗？

是的 — 「使用 Q 对象进行复杂过滤」的完整文本可在网页上免费阅读。要进行交互式练习（内置代码编辑器和全天候 AI 导师）并解锁 Django Academy 课程的其余内容，请升级到 CoddyKit PRO。 Django Academy 课程共包含 4 节课。

「使用 Q 对象进行复杂过滤」这节课中我会学到什么？

使用 AND、OR 和 NOT 组合条件你通过在浏览器中直接运行的动手代码来练习 Django Academy，全天候 AI 导师会在你学习这节课的过程中回答你的问题。

学习 Django Academy 需要有经验吗？

无需任何先前经验。CoddyKit 上的 Django Academy 课程适合初学者到高级学习者，你可以从这里开始或从头开始，按照自己的节奏学习。这是第 3 节课，共 4 节。

「使用 Q 对象进行复杂过滤」课时需要多长时间？

大多数 CoddyKit 课程大约需要 5–10 分钟。每节课都很精短且互动，所以你能稳步进步，并在网页和应用中从离开的地方继续。

我能在这节 Django Academy 课中编写并运行代码吗？

能。每节 Django Academy 课都包含内置代码编辑器，你可以在浏览器中直接编写并运行真实代码，并获得即时 AI 反馈 — 无需本地设置。

此课程中的所有课时

← 返回 Django Academy