Not able to use annotate

[manoj-punchh]

Is there any way to use async with annotate or subquery, count etc.?

filter(query).order_by(order_by).values('pname').annotate(pname=F('pname'), counts=Count(
            'plocation'))

[iann838]

@manoj-punchh It should work just like that, what error do you find using it ?

[manoj-punchh]

Error object AsyncQuerySet can't be used in 'await' expression

Here is how I'm making query

data_list = await Policy.aobjects.prefetch_related('plocation_set')
.filter(query).order_by(order_by)
.values('pname')
.annotate(pos_name=F('pname'), applied_locations=Count(
                'plocation'))
.values('id', 'name', 'status', 'created_at', 'updated_at', 'applied_locations', 'poname').distinct()

[manoj-punchh]

Ok thanks , Now I get it working after adding eval at the end of the query.

data_list = await Policy.aobjects.prefetch_related('plocation_set')
.filter(query).order_by(order_by)
.values('pname')
.annotate(pos_name=F('pname'), applied_locations=Count(
                'plocation'))
.values('id', 'name', 'status', 'created_at', 'updated_at', 'applied_locations', 'poname').distinct().eval()