Django Queryset with filtering on reverse foreign key

by

Yes, I think you want

make = Make.objects.get(pk=1)
make.make_content_set.filter(published=True)

or maybe

make_ids = MakeContent.objects.filter(published=True).values_list('make_id', flat=True)
makes = Make.objects.filter(id__in=make_ids)

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. How can I combine two or more querysets in a Django view?
  3. Django filter queryset __in for *every* item in list
  4. How do I do an OR filter in a Django query?
  5. Custom QuerySet and Manager without breaking DRY?
  6. Raise a validation error in a model’s save method in Django
  7. Why does django’s prefetch_related() only work with all() and not filter()?
  8. Select DISTINCT individual columns in django?
  9. _set in Django for a queryset
  10. Raw SQL queries in Django views
  11. How to limit queryset/the records to view in Django admin site?
  12. Django: implementing JOIN using Django ORM?
  13. Django – filtering on foreign key properties
  14. How to create a Django queryset filter comparing two date fields in the same model
  15. How to query Case-insensitive data in Django ORM?
  16. Can Django automatically create a related one-to-one model?
  17. Django Pass Multiple Models to one Template
  18. How to dynamically provide lookup field name in Django query? [duplicate]
  19. Django: ManyToMany filter matching on ALL items in a list
  20. Django query datetime for objects older than 5 hours
  21. Django, query filtering from model method
  22. Django: Does prefetch_related() follow reverse relationship lookup?
  23. django most efficient way to count same field values in a query
  24. Django Order By Date, but have “None” at end?
  25. Django query case-insensitive list match
  26. Django: __in query lookup doesn’t maintain the order in queryset
  27. Django self-recursive foreignkey filter query for all childs
  28. Django queryset get exact manytomany lookup [duplicate]
  29. how to write a query to get find value in a json field in django
  30. Django: Using F arguments in datetime.timedelta inside a query

Leave a Comment