Django in / not in query

by 
table1.objects.exclude(id__in=
    table2.objects.filter(your_condition).values_list('id', flat=True))

The exclude function works like the Not operator you where asking for. The attribute flat = True tells to table2 query to return the value_list as a one level list. So… at the end you are obtaining a list of IDs from table2, which you are going to user to define the condition in table1, that will be denied by the exclude function.

More Related Contents:

  1. How can I see the raw SQL queries Django is running?
  2. Django select only rows with duplicate field values
  3. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  4. How to select a record and update it, with a single queryset in Django?
  5. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  6. Using django how can I combine two queries from separate models into one query?
  7. Insert local .csv data in remote SQL Server via already working connection string
  8. The most efficient way to UPPER CASE two columns in a single query [closed]
  9. SQL query to get rows by comparing data in different columns
  10. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  11. Does the join order matter in SQL?
  12. Case insensitive searching in Oracle
  13. How to use ANY instead of IN in a WHERE clause?
  14. Is there a shortcut for SELECT * FROM?
  15. How to get difference between two rows for a column field?
  16. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  17. How to find the employee with the second highest salary?
  18. SQL Server SELECT into existing table
  19. Rewriting mysql select to reduce time and writing tmp to disk
  20. Including null values in an Apache Spark Join
  21. How to kill a running SELECT statement
  22. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  23. Is there AUTO INCREMENT in SQLite?
  24. How to Alter Constraint
  25. Group by with CLOB in select-statement
  26. SQL Server Operating system error 5: “5(Access is denied.)”
  27. Performance of Cross join with WHERE clause compared to Inner join
  28. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  29. How to pass a temp table as a parameter into a separate stored procedure
  30. Querying Active Directory from SQL Server 2005

Leave a Comment