models.py
class Iso(models.Model):
service_type = models.CharField(max_length=100, blank=True, null=True)
field_1 = models.IntegerField(blank=True, null=True)
field_1_size = models.IntegerField(blank=True, null=True)
field_2 = models.IntegerField(blank=True, null=True)
field_2_size = models.IntegerField(blank=True, null=True)
In my views.py I have two queryset as follows, now if I want to combine together the queries and if user enters the field_1 value and field_2 value same, it should be summarized.
qs1 = Model.objects.values('service_type', 'field_1')\
.annotate(field_total=Sum('field_1_size'))
qs2 = Model.objects.values('service_type', 'field_2')\
.annotate(field_total=Sum('field_2_size'))
I tried, qs_tot = qs1.union(qs2) it combines queryset but not gives a sum value, if the field_1 and field_2 are same. Any helps will be greatly appreciated. Thank you.