Context Navigation

Changes between Initial Version and Version 1 of Ticket #36352

-              initial
+              v1
 django.core.exceptions.FieldError: Cannot select the 'created' alias. Use annotate() to promote it.
 }}}
+Current workaround is to include the annotated field in .values like so
+{{{
+>>> c = b.filter(id=OuterRef('id')).values('schema', 'created')
+>>> d = Tenant.objects.values('schema_name').annotate(created_at=Subquery(c.values('created')[:1]))
+>>> d[:1]
+<QuerySet [{'schema_name': 'sample', 'created_at': datetime.date(2024, 11, 4)}]>
+}}}