help been on that for 5 days, Joining 4 tables on 2 columns

[Omar aboul makarem]

Hey Guys please help

I have Approval model, and i want to calculate the sum of total prices of the procedures based on the company and procedure type in each Approval

https://www.ppaste.org/pwhJ6u7Dg

now i want to get all the prices and .aggregate(Sum('price'))['price__sum']) to get the sum of all prices of the approvals i have.

the raw sql for postgresql and if my app is called main is :

now how can i change this sql to django ORM, in the documentation i read about select_related(), and F(), but i dunno how to use it in this case

[Integr@te System]

Hi Omar,

You can look at this to consider:

https://hakibenita.com/django-group-by-sql 

Hope this helpful.

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/038b6c05-0be2-43b2-8082-f24e08858a92o%40googlegroups.com.