Thanks Simon, that's a great help.
On Wednesday, 31 July 2019 15:03:55 UTC+1, Simon Charette wrote:
>
> Hello,
>
> assuming you have a FullMatch model mapped to your FullMatches table
> the following should do.
>
> FullMatch.objects.filter(
> job_id=job_id,
> ).values(
> seq=Concat('loading_code', ...),
> ids=Concat('loading_id', ....),
> ).annotate(
> total=Count('*'),
> ).order_by('-total')
>
> Using .values() before an annotation of an aggregate function uses the
> provided columns
> from grouping.
>
> Cheers,
> Simon
>
> Le mardi 30 juillet 2019 12:56:56 UTC-4, Jonathan Spicer a écrit :
>>
>> Hello,
>>
>> I have an sql query that I would like to recreate using the ORM. Would it
>> be possible for someone to give me some pointers.
>>
>> select count(*) as total,
>>
>> concat(loading_code,code1_code,code2_code,code3_code,code4_code) as seq,
>>
>> concat(loading_id,',',code1_id,',',code2_id,',',code3_id,',',code4_id) as
>> ids
>> from FullMatches where job_id = %s group by seq, ids
>> order by total desc
>>
>> Thanks in advance.
>>
>> Johnny
>>
>
--
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/5f6f271a-4d8d-4d02-80c3-9085f15f6ce4%40googlegroups.com.
