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
32297	QuerySet.get() method not working as expected with Window functions	Jerin Peter George	nobody	"I have a simple model as below, 


{{{
class Employee(models.Model):
    name = models.CharField(max_length=40, blank=False, null=False)
    salary = models.PositiveIntegerField()
}}}

and I queried 

{{{
qs = Employee.objects.annotate(
    rank=Window(expression=Rank(), order_by=F(""salary"").desc()),
)
}}}



and then I have called the `get()` method to get the rank of a single specific object


{{{
qs.get(pk=pk).rank
}}}

**Issue**

The `get(pk=pk).rank` returning a constant value irrespective of the `kwargs` applied to the `get()` method
"	Bug	new	Database layer (models, ORM)	dev	Normal				Unreviewed	0	0	0	0	0	0