Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#8657 closed (invalid)

How to do a "... where field NOT IN (select field ..."

Reported by: Nate Thelen <nate@…> Owned by: nobody
Component: Documentation Version: master
Severity: Keywords: filter in
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:


I have searched your site and the web and cannot find how to do a:

"... where field NOT IN (select field ..."

The docs explain the "fieldin" method which works perfectly, but I cannot find an equivalent notin or a way to negate the whole thing. I have tried everything I can think of


Change History (2)

comment:1 Changed 7 years ago by mtredinnick

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Resolution set to invalid
  • Status changed from new to closed

Please ask support questions on the django-users mailing list. But the method you're looking for is exclude().

comment:2 Changed 7 years ago by Nate Thelen <nate@…>

Cool, thanks. It felt like a documentation problem, but I know where you are coming from. Thanks!

Note: See TracTickets for help on using tickets.
Back to Top