Opened 10 years ago

Closed 10 years ago

Last modified 10 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: no UI/UX: no


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 10 years ago by Malcolm Tredinnick

Resolution: invalid
Status: newclosed

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

comment:2 Changed 10 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