From 0b24584e78f2c211343230b33fde137231e4341d Mon Sep 17 00:00:00 2001 From: Stepland <16676308+Stepland@users.noreply.github.com> Date: Mon, 16 Sep 2019 16:19:02 +0200 Subject: [PATCH] Add note on the use of tuple_() for the IN operator --- doc/build/orm/tutorial.rst | 3 +++ 1 file changed, 3 insertions(+) diff --git a/doc/build/orm/tutorial.rst b/doc/build/orm/tutorial.rst index 14ea82a0dd..3e3ac0cd4a 100644 --- a/doc/build/orm/tutorial.rst +++ b/doc/build/orm/tutorial.rst @@ -783,6 +783,9 @@ Here's a rundown of some of the most common operators used in session.query(User.name).filter(User.name.like('%ed%')) )) + .. note:: for composite (multi-column) IN queries, group columns together + using :func:`.tuple_` + * :meth:`NOT IN <.ColumnOperators.notin_>`:: query.filter(~User.name.in_(['ed', 'wendy', 'jack'])) -- 2.47.3