My question is about translating a SQL query to the ORM.
I want to combine the output of two queries into one. The query is
counting records in the same table (Task) using two different fields.
The query is:
select q1.taskname, q1.count, q2.count, (q1.count + q2.count) as total from
(
select ptt.name as taskname, count(1) from task pt
inner join tasktype ptt on pt.type_id = ptt.id
where pt.created >= '2022-11-05T00:00:00+00:00'::timestamptz
group by ptt.name) q1
left join (
select ptt.name as taskname, count(1) from task pt
inner join tasktype ptt on pt.type_id = ptt.id
where pt.completed >= '2022-11-05T00:00:00+00:00'::timestamptz
group by ptt.name) q2
on q1.taskname = q2.taskname
This gives an example output of
taskname count1 count2 total
=======================================
1st review 8 4 12
2nd review 4 13 17
This works fine using raw SQL, but is it possible to do this using the ORM?
Thanks
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAAcKVnmMWftvzceQJeBFYMKfBuOHZVgRGi%3D8BvoZts%3DaUY%2Bmyg%40mail.gmail.com.
