Negate a Q object in Django

Question

I have a complex Q object created dynamically. How do I negate the Q object so that it can be used in filter() instead of exclude()?

score 17 · Accepted Answer · answered Feb 07 '14 at 05:21

17

Use ~ operator:

complex_condition = ~Q(....)

Q objects can be negated using the ~ operator, allowing for combined lookups that combine both a normal query and a negated (NOT) query

answered Feb 07 '14 at 05:21

falsetru

1

@ATOzTOA, `operator.not_(x)` is similar to `not x`. Use `operator.inv(x)` or `oeprator.invert` to mean `~x`. Sorry for late (too late) reply. https://docs.python.org/3/library/operator.html#operator.inv – falsetru Apr 19 '19 at 15:24

score 1 · Answer 2 · answered Feb 07 '14 at 05:37

1

Thanks @falsetru.

What I was trying was running the Q object through another negated Q object:

~Q(Q)

answered Feb 07 '14 at 05:37

ATOzTOA

score 0 · Answer 3 · answered Dec 14 '20 at 09:19

If you cant use ~ operator like ~Q(**filters) - use operator.inv(q)

import operator
negated_q = operator.inv(query)

Usage Example

q_filter = Q(user__profile_id=777)
>> (AND: ('user__profile_id', 777))

negated_q_filter = operator.inv(q_filter)
>> (NOT (AND: ('user__profile_id', 777)))

3 Answers3