Django Q object filtering guide with complex annotations in PostgreSQL
I'm experiencing an scenario while trying to filter a Django QuerySet using Q objects with complex annotations in PostgreSQL. Specifically, I'm trying to annotate a queryset based on a condition and then filter on the annotated value, but it seems like the filtering is not working as expected. My code looks like this: ```python from django.db.models import Q, Count, F from myapp.models import Order # Trying to annotate and filter orders based on total quantity orders = Order.objects.annotate( total_quantity=Count('items') ).filter( Q(total_quantity__gt=5) | Q(total_quantity__lt=2) ) ``` When I run this, I expect to get orders either with more than 5 items or less than 2 items, but I'm not seeing the correct results. In fact, it seems like all orders are being returned regardless of the filtering, and when I print the SQL query using `str(orders.query)`, it looks correct. However, the results are not what I anticipate. I've also tried using `.exclude()` instead of filtering directly, but the outcome is still the same. The version Iām using is Django 4.0.1 with PostgreSQL 13.3. I've thoroughly checked for any typos and ensured that the related fields are correctly defined in the Order model. Am I missing something in my filtering logic, or is there a limitation when using Q objects with annotations in Django? My team is using Python for this CLI tool.