Re: Combining two subquery counts using ORM

Post your model here and we do it

On Wed, Nov 9, 2022, 7:37 PM Matthew Hegarty <mrhegarty@gmail.com> wrote:

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 django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAcKVnmMWftvzceQJeBFYMKfBuOHZVgRGi%3D8BvoZts%3DaUY%2Bmyg%40mail.gmail.com.

--
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 django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMVv_-EERCWrqmTmFrKJCNjRnzuX-xeuJ_O3qvkS1TCLX%3D-o6w%40mail.gmail.com.