id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
34957	"Cannot filter over annotated ""FilteredRelation"" since Django 5"	younes-chaoui	nobody	"After updating  to django 5.0b1 I get test fails when using a filter over annotated ""FilteredRelation"". This is an example :

{{{
from django.db.models import F, FilteredRelation, Q
visites = (
    Visite.objects.all()
    .annotate(
        etat_at_date_de_visite=FilteredRelation(
            ""site__siteusage__etats"",
            condition=Q(site__siteusage__etats__date_valeur=F(""date_de_visite"")),
        )
    )
    .filter(etat_at_date_de_visite__isnull=False)
)
print(visites)
}}}
"	Bug	new	Uncategorized	5.0	Normal				Unreviewed	0	0	0	0	0	0